Find next available row based on a range then create links between two sheets

[Titchy Dean]

So I've been creating a workbook that manages projects.

My problem is I want cell links to be created automatically when a new sheet is created.

When a user selects 'Add New Project' button the workbook makes a copy of a Project Template. I want the 'Project Dashboard' worksheet to have links to the new project template which will eventually show specific values in the next available row. Links such as (i.e = NewProjectSheet!A1 in cell B5 on the project dashboard)

(In the attachment, the 'Test' worksheet is resembles a 'new project template')

Test.xls

I specifically need help with VBA code to find the next available row based on the range (B5:F23) then create cell links in that new row.

Is this possible? If so can anyone give me a hand?

Many Thanks