"JakeShipley2008" wrote...
To explain better, I have a macro written that imports new sheets to my
active workbook. I do not know the names of the new sheets until the files
are imported.
I want to move the data with a simple ="sheet1!A1" function howver since I
do not know the sheet name I am unsure how to do this.
....

Couldn't the macro that imports these worksheets also enter formulas? When
you import a worksheet, it becomes the ActiveSheet in that workbook. You
could get its name using

wksname = ActiveSheet.Name

then copy template formulas and replace the template worksheet name with the
new worksheet's name.