hi,
yes. Filesaveas then give it a new name.

Regards
FSt1

"Todd Nelson" wrote:

Can I copy an entire file into a new workbook, without changing the sheet
names. (ie keeping them sheet 1, sheet 2, sheet 3)? I need to pull the same
cell in each sheet however the formula I have only works if sheets are named
as such.