Best method of combining many Excel sheets and workbooks

[Stevon]

Hi

So I have a bit of a data cleansing problem for work.

I have approximately 20 workbooks all containing approx 25 sheets and I've been asked to combine all of this data into one master sheet.

The problem is that whilst all of the sheets have some of the data that we need, the column formatting isn't standard across them all and most have several columns of data that we don't need in the final product.

It's looking like a very laborious cut, copy and paste exercise unless there are some tools or methods that I'm not considering?

Just wondered if anyone had any advice for this?

Thanks

 

[sandy666]

maybe Power Query

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference

 

[Stevon]

Thanks for the pointed Sandy.

I found a video on YT that did exactly what I wanted (link below for future reference)

 

[sandy666]

You are welcome
Thanks for the feedback