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.