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

Linking data from one worksheet to another... 2
Tying Several Worksheets Together in One Worksheet 3
linking worksheets to a closed workbook 2
pulling data into a master sheet from multiple worksheets 3
combining data from multiple worksheets into one 6
Auto update worksheets 6
Link from 1 worksheet to 4 different worksheets 1
How to sort data from one worksheet into other worksheets? 2

Top