OK, no problem. We'll take it slow. :wink:
When you save & close (or open) a file, that's the workbook.
Within the workbook are several (or any number of) worksheets. You'll see the sheet names in little tabs on the lower left part of your screen.
(Unless they've been renamed they'll be "Sheet1", "Sheet2", Sheet3", etc.)
What we need to know is if all your users are entering their data into separate workbooks (files), or if they are all on their own worksheet within the same workbook.
I suspect they are all in their own workbooks but need to know for sure.
As for the vba, we'll get to that in a bit. All that is, is the code behind a button that you'll click to automatically perform some function(s).
Once I understand exactly what you're working with I'll walk you through how to do it manually. Then we should be able to automate some or all of it for you.