Is there any way to push data from one sheet/workbook to another sheet/workbook, instead of just pulling it like you would normally do by using external references?

I need to have one sheet that will be read-only, and then filled in with data and constantly saved as something else, so there will be many versions of it. I then need some of the data from those sheets to be pushed into another sheet, cumulatively, so all the data from all the different versions will be available, instead of it just getting written over every time there is a new version saved.

Help!