0

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

0

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.