I've got a summary page for a business of mine with about 100+ sheets on the same Google Sheet (if that makes sense -- so it isn't =importdata). The 100+ sheets are for customers and they use the same template. I'm looking to auto-fill the summary sheet with each of the customers' data from their respective sheets. How do I do this? Each of these pieces of data is a single cell but the same cell on all customer sheets.

I'm sure there's a way to do this without me having to go to each sheet and select the cell for the summary page to link.

Here's a picture of the summary sheet and a single customer with the function showing where it's pulled from their respective sheet:

Summary Sheet with Customer Business Type Highlighted


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.