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. Attachment 186193