When I create a macro that links data from one sheet to another, is there a way to only do so if the sheet is new?

To explain:
I currently have a workbook that I use to track expenses from multiple jobs. (I use the expenses to create various metrics for profitability etc.)

For each new job I create a new job worksheet within the workbook, add the data, and then link that data to a unique row in a summary sheet (in table form).
The summary sheet is where I have various filters and computations to derive the information I need.

The format of each job worksheet is identical to each other.

The problem I have is that for each new job (and there are hundreds) I have to add a new worksheet ( I copy the template) then link that worksheets data to a new row in the summary table.

I had the idea of creating macro on the job worksheet template that would automatically perform the links to add the data to the summary page. Then when I copied the template to create a new job, the macro would carry over and by pressing the button I assigned the maco on the job worksheet page, the data would automatically fill the summary worksheet.
This works, sort of, because when I created the initial macro i used "Sheet one" it always creates the data from "sheet one" - Duh!

Is there a way to either:
1)automatically adjust my existing macro to whatever I call the new sheet "sheet one", "sheet two"
2) is there a way fix my macro so that it only copies over data from new sheets
3) Other solution

Thanks for your help.