Automatically copy certain line items of one sheet into another

Hi

Is it possible to somehow copy certain cell info from one sheet into another without having to repeat the action 100 times.

I am working on a workbook which will contain more than 90 sheets that look exactly the same, but with different data. I then have to extract certain information (same cells of each sheet) into a single sheet of the same workbook named "Dash". All sheet's contain a hell of a lot of information, and it's going to take forever having to = click on relevant sheet and select cell then enter for each of them...

I also have to create hyperlinks to the project name to take me to the relevant sheet of the selected project (which i'm able to do manually), is there a way that i can also automate this action?

Any help is held in high regard.

I attach an example doc from which I'm testing. TestDoc.xlsx