Hi,
I'd like to create a master spreadsheet in excel that will automatically gather and compile data as it is entered in individual 5 different spreadsheets. Basically, there are five separate people entering data and each sheet has same number of column. As people are adding data, I would like for this data to be synched to a master spreadsheet entitled. Is this possible?
Thanks!
Piyush