Looking for a way to make a master list from data in other sheets

[jlehrer76]

I have put together 70 sheets of snow plow route cards, I want to pull certain cells from the route cards and list them on a master list that is easy to look at. ie Name, address, notes? I know there is a way but I cant figure it out and its make me crazy.
What I want on the index sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]Inches[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What my sheets have on them
[TABLE="width: 500"]
<tbody>[TR]
[TD]City
[/TD]
[TD]McCall
[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]John Smith[/TD]
[/TR]
[TR]
[TD]Inches[/TD]
[TD]6-8[/TD]
[/TR]
</tbody>[/TABLE]

 

[shift-del]

Jlehrer76,

that would be job for Power Query alias 'Get and transform'.
Look for the ExcelIsFun-channel on YouTube for detailed video tutorials.

 

[My Aswer Is This]

You said:
I have put together 70 sheets

Is this all the sheets in your workbook

So we want to add a new sheet named "Master" and copy all the data from the other 70 sheets into sheet named "Master"

If that is what you want we need exact details about where is this data on your seventy sheets and where do you want it put on your master sheet.

If you only want certain data copied over we need to know what columns and rows on each sheet is this data.

 

[jlehrer76]

I only want to pull certain data from the same cell in every sheet and show them as a list

 

[My Aswer Is This]

We need exact details:

You said:
I only want to pull certain data from the same cell in every sheet and show them as a list


What data what cell what list?