Offset function with nested linked cells

Hi all,
Sorry if the title is misleading. However I need to resolve a function in my worksheets to make use of the table easier.
I have a set of worksheets that contains the raw project data, then a head worksheet that contains selected summary information.
In the summary worksheet, I have linked the cells and used the offset function relative to the project number. The project number is directly linked to the project number in the data worksheets.

The ponly problem is, each time a new row is created for a project that is added, you need to manually insert the reference cell location in each cell offset formula (or use find and replace) related to that project.

I want those cells to look at the project number in each row, based on that find it in the relative worksheet and then use the offset function to pull in the relative data. It would be also ok to manually insert the Project number rather than linking it as they are sequential.

Is this even possible? I have attached a sample of the document for reference. Thank you in advance!