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

There's a couple of ways to do it...
The most common is VLOOKUP()

I don't personally like this function and pretty much always use =offset() and in the row field I use match().

I don't really understand the sheet you attached, but you can create the links with a macro.

Hi Pinball4530

thanks for getting back to me on this.

the test doc should work as follows: the Heading of each sheet (Test 1 & Test 2) should be hyperlinked to "Dash" heading "project name", row A2 of each sheet should reflect in "dash" under the Update column and the dates in columns B2 of each sheet should reflect in the Dates column of "Dash".

I've tried the macro but was unsuccessful, and the forulas i've used aren't working.

I know how to create the hyperlink, but it would be useful if i didn't have to do it 90 times over.

Any ideas?

I don't think I follow since what I understood has a way to easy solution.
In cell A2 of dash enter =Test1!A1
In cell B2 of dash enter =Test1!A2

If you're thinking no no no, can you fill in some data on how you want it to look?

Creating the hyperlink with a macro will be easy...once I get unconfused

I know the easy way of doing it, but it is very manual. i'll ultimately have 90 spreadsheets that I'll need to use to populate the Dash. i was hoping there is a way that i could populate the dash without having to type in each line automatically or having to go through each sheet to select the required cells that will populate the dash.

also, if you use a Macro to create the hyperlink, it links to only one sheet, it won't link to all 90 sheets unless 'n i creat 90 macro's

i don't know how else to explain it.. i hope this makes a little more sence.