static formula possible?

I have a macro that generates several tabs of lookup tables. The tabs are named (lets say "table 1", "table 2", etc...). In my main worksheet, I have a lot of formulas that reference their respective tables. The problem is the worksheet itself works like a template and the tabs are not generated until the macro runs so the formulas do not have a reference point (=VLOOKUP(A1,#REF!A:B,2,FALSE). Is there a way to lock in the tab name into the formula?

tldr - my formula is =vlookup(A1,table1!A:B,2,False) but the table1! turns into #REF! because the tabs are not generated until the macro runs.

i really appreciate the help. This was exactly what i was looking for.

thanks