Auto Populating Fields from many worksheets to one main worksheet

V

Vincent

I'd like to have a master spreadsheet that will house all data I input on
other worksheets. I need to create one sheet per person and enter data on
each person seperately but i'd like it to all be automatically copied to the
MAIN/MASTER sheet.
So if you were to see the tabs for workbooks, it would be like:
Master Destination Worksheet...Person Source 1.....Person Source
2.....Person Source 3.....ect. Id like anything I put into any of those
sources to automatically go into the Master Destination.
Is that possible? The only instructions I could find involved formulas.
I would appreciate any help possible.
Thanks so much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syncing between source worksheet and dependent worksheets 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Linking data from one worksheet to another... 2
multiple worksheets 1
combining data from multiple worksheets into one 6
Transfering info from main worksheet to multiple worksheets 0
Automatic Update in Multiple Worksheets 0
How to update data from linked worksheet back to a master worksheet? 0

Top