DataTable stores large volumes of data outside your sheets and maintains a live connection between them. Create a DataTable, then connect a sheet to it to automatically sync a subset of that data.

Once connected, updates in DataTable flow into your sheet without manual re-entry.