Probably not, but here's a starting point:
Open the "new" spreadsheet.
Turn on the macro recorder.
Open one of the 16.
Manually perform the steps you want.
Stop the macro recorder.
Using Alt-F11, look at the code that was created.
Ask a specific question if you still need to.
_________________
Bob Rashkin