Create a master spreadsheet that automatically compiles and updates all data entered

[piyush23y]

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

[vlady]

Welcome to the forum.