Hi all - Please help me create a very basic formula on how i could create a single data dump file. I'm fairly new in excel and still learning things. Here's what I would need to do.automatically transfer the data saved in the Raw Data sheet of all 13 employees.

Each employee has their own tracker that they update daily. They use Sheet1 to encode the data, there is a save button that they will have to click in order to transfer it to the Raw Data Sheet. I would like to know what formula i can use to transfer all the information from the individual Raw Data Sheet to a Dump File real time.

Thank you in advance.