Merge multiple excel files into different tabs of one workbook using Power Query on Mac

rachel 

You've had over 60 views and no replies. Not sure exactly why that is, but it may be that not a one of us is sure how exactly to help.

I'd like to ask, if you are willing to answer, that you tell us a bit more what kind of data are in each of these 33 separate sheets. I ask because it's often the case that people think they're making things clearer, easier to understand, by breaking common or recurring data sets--you do note that they all are arranged the same--into separate sheets. In fact, although that may be clearer to the human, it interferes with Excel's remarkable abilities to store and parse data. For example, if each of these is for a different product line, or a different month, or a different store....assembling all that data into a single sheet would enable you to still pull out the data for the single product line, or month, or store (or whatever), AND to do all kinds of high level summaries as well, very easily.

So before trying to solve the problem of importing each sheet into its own tab in a single workbook, let's talk about another possible way to assemble the data.....if you're willing.

If the data are not confidential, maybe you could help us help you even more effectively by posting a copy of several of these sheets on OneDrive or GoogleDrive, with a link here that grants access.