I have 96 different spreadsheets. I would like to make this one master
spreadsheet. Make a version control so when the user opens the spreadsheet it
will connect to my access database and it will tell the user they need the
new version. That part is all set.

I need help on coping the information from the old spreadsheet into the new
spreadsheet. What is the best way of doing this? I have many built in
functions to the menu bar as well. Is there a copy all excel spreadsheet and
past all into another spreadsheet.

Thanks in advance