PowerQuery | Multiple Tabs (in Excel) as Source

[ovetteabejuela]

Hi,

I am extracting data from multiple tabs in the same Excel sheet. Each sheet is identical, so the value that I'm interested in can be found in the same location (Cell B6 for example).

What I'm planing to do is to create a single query for each tab (1:1). But that is so elementary, is there a better approac to this, 1 Query that can handle all tabs.

Hi @ImkeF, have you ever worked with something like this before?

[ovetteabejuela]

I found this resource from @KenPuls, however this only works witha single source:

https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/

I would want to work with multiple excel files that has multiplle tabs ("Get Data from Folder")

[ovetteabejuela · Accepted solution]

Hahaha!

I'm so happy, I think I can go home now and get a good night sleep (we'll technically it's morning).

I may have to thank @MarcelBeug for this because I learned this from him long time ago.

The secret with this problem is "Excel.Workbook([Content]))", using that I am able to expose the contents of the workbook.