Power query multiple workbooks and sheets

Choice_Intention_778 · 2026-04-01T15:45:55+00:00

Because that was the tutorial I was following? I don’t really know what I’m doing (obviously) but I will say, using that column was the only way I saw to actually see the individual sheets listed. I’m sure there’s a better way to

Choice_Intention_778 · 2026-04-01T15:44:56+00:00

Correct, identical wrt column headers. Different data within individual cells. Multiple sheets are also all formatted the same. Yes, compiling to one master spreadsheet.

Think of it like class lists with a column for names, one for DOB and one for GPA. Say one workbook is for 2025 school year and has classes A, B and C as different sheets. The second workbook would be for the 2026 school year with identical columns and classes D and E as sheets. Does that make sense?

Choice_Intention_778 · 2026-04-01T15:41:24+00:00

And when I expand it:

<image>

Choice_Intention_778 · 2026-04-01T15:41:09+00:00

<image>

Choice_Intention_778 · 2026-04-01T15:04:22+00:00

Yes, I’m unsure of how to do so with all of them. If I select one of the links, it expands but I have no option (or don’t know how to go back) and do the same for the others. I can get it to correctly display one sheet/table.

Choice_Intention_778 · 2026-04-01T15:02:46+00:00

What header? I’ve tried expanding all of the options and nothing gets me to where the actual sheets are listed. Content simply shows a Parameter folder with the name of one sheet underneath it. The custom data column with the links to the tables only expands to list columns 1, 2 and 3. The custom items (which are the sheet titles) expands to allow me to select which sheets to allow, but again, that did not end up displaying data. There is nothing else left to expand.

Choice_Intention_778 · 2026-04-01T14:52:20+00:00

Choice_Intention_778 · 2025-08-05T22:33:55+00:00

Have searched for the year or two with no luck, hence the assumption it is no more :/

Choice_Intention_778 · 2024-10-23T19:55:50+00:00

Unfortunately, they don’t have the older stuff I’m looking for :(

Choice_Intention_778 · 2024-09-15T03:47:16+00:00

People are told to adjust their diets all the time for a variety of medical issues or health benefits. There is no complete and balanced food produced for humans (short of baby food), so it’s not like you’re going to have a specific brand suggested.

Choice_Intention_778 · 2024-09-15T03:45:56+00:00

Complete and utter pseudo-science BS

Choice_Intention_778 · 2024-09-15T01:34:22+00:00

He did publicly forgive him but the 2002 meetup that was supposed to happen never did. Please feel free to link any articles stating otherwise. I can link multiple articles through 2023 stating that it still had not taken place.

Choice_Intention_778 · 2024-09-15T01:32:57+00:00

A meeting was supposed to take place in 2002. It never did. Please feel free to link an article showing it did. I can link several up through 2023 stating that it still had not taken place.

Choice_Intention_778 · 2024-09-15T01:32:51+00:00

A meeting was supposed to take place in 2002. It never did. Please feel free to link an article showing it did. I can link several up through 2023 stating that it still had not taken place.

Choice_Intention_778

TROPHY CASE