I would like to move sheets from one Excel workbook into another. Currently,
I have a template that requires me to copy and paste one sheet at from one
workbook to the other. Workbook1 contains data from a report that I run.
Workbook2 is my template.

How can I write formulas in workbook2 so they will read data from the newly
added sheets that came from workbook1?

The sheet names are the same each time.