Unable to edit macro recording code to be a relative code.

Hello,
I tried recording a macro to automatically equate cells from a newly created workbook (also part of the macro) to another workbook to create a sort of a database.
So "template 5 was created, and I manually made the cells on the "database" worksheet, equal to those some on template 3.
Here is the code from that recording.

Please Login or Register  to view this content.

Notice how the code did absolute referencing for template 5. Is there a way to edit this code so that when a new worksheet is created through the macro, those cells from the new worksheet automatically are filled on the "database" worksheet?

I dont know any VBA coding so I am trying to find a way to make this as simpler as possible.

Appreciate any/ all help a lot!

This isn't a VBA solution to the cell referencing question, it's a formula suggestion. You can use INDIRECT() formulas to construct cell references from text strings.

For instance, if on my template sheet called "Template (5)" I wanted to see the value of cell B5, it would do this in my database sheet:

1) In an empty row I'd add the new sheet name to column A
2) Then I'd add INDIRECT() formulas on the same row grabbing cells using the column A sheet name.

Please Login or Register  to view this content.

This puts this formula in column B if the next row (NR) were row 5:
=INDIRECT("'" & A5 & "'!B5")

So just expand on that. This way, you need only grab the new sheet name once, add it to column A, then drop in the same INDIRECT() links on the same row to create your links.