VB Code That returns all entries form all sheets to one worksheet or workbook.

Good Morning Forum!

I am looking to return what staff are entering into their spreadsheet into my spreadsheet. I am thinking perhaps VB would be the way to go. It is similar to merge but it would automatically return it to my spreadsheet so I can track staff in real time.

Thanks!

~bonnie

I am thinking this will be similar to a merge macro but might have a two part solution, one to aggregate the information when the worksheet is saved and the other to navigate it to the correct page to return the information to? Anyone have any suggestions?