Values from mulitple Tabs

[jrisebo]

I have a spreadsheet with multiple tabs (about 30). I want to pull and make a table or condense into a column on one tab. The cell will always be the same, lets say A1.

How can I do this with code, regardless what the tab names are?

 

[SanjayGMusafir]

Know very less about it but from Educational Videos I have seen Power Query is the answer for you. It can help you merge and organise data from multiple tabs. Shall share some link to the video If able to find one.

Edited:
Here is the link for you. Hope it helps

 

[jrisebo]

Maybe I explained this wrong. I want to combine every A1 value from every tab into a column in a new sheet. Not every sheet into A1

 

[SanjayGMusafir]

Kind of tedious thing... Following thread to understand what experts think as a solution to your problem...

 

[Fluff]

@SanjayGMusafir what exactly do you mean? You are the only person who has posted to this thread.

 

[Fluff]

@jrisebo how about using vstack like

=VSTACK(Sheet1:Sheet6!A1)

 

[SanjayGMusafir]

@SanjayGMusafir what exactly do you mean? You are the only person who has posted to this thread.

I don't know what you grabbed @Fluff - I just wanted to say that I will learn from what experts would reply to the problem. So was eagerly waiting for someone to respond. Hope I have not made any offence to anybody... Apologies if I sounded that way...

Regards

 

[jrisebo]

Thanks all. I used a macro to list all my tabs, then =INDIRECT("'"&A2&"'!A1") for each tab to pull A1.

 

[SanjayGMusafir]

Thanks all. I used a macro to list all my tabs, then =INDIRECT("'"&A2&"'!A1") for each tab to pull A1.

Honestly @jrisebo I was still confused about what you wanted to achieve. But glad you found a solution.

 

[jrisebo]

Honestly @jrisebo I was still confused about what you wanted to achieve. But glad you found a solution.

From all my tabs, I wanted to pull cell A1 value from each into a column on a sheet.