Combine Multiple Worksheets into One with Append Query - Excel

In this video, we combine multiple worksheets into one in Excel using the Append Query.

There are a few methods for combining worksheets in Excel. Using the Append Query is one of the best.

Once the query is created, it can be refreshed with the click of a button in the future to reflect changes in the other worksheets.

Find more great free tutorials at;

Connect with us!

[nochanceofmyname]

Brilliant mate. I was on the right path, but getting stuck, and this clarified exactly what I needed.
I'm going to do this first in excel, letting the business areas update their own data in locked-down sheets, then load the single appended file to Power BI for an extremely lightweight and quick report.

[Kkratika]

I wasted almost 3 hours and finally found your video. It is simply awesome. Thank you, you made my day..:)

[charlesalvear]

Allan, believe me when I see that my eyes nearly popped out of my head at 9:20 !! This is excellent info and exactly what I needed to combine two sheets containing future and historical timesheets for my team.

[danushairan]

Love the guys who make tutorials straight to the point like yours.
I watched for 4 min and got what I needed Thanks man big time help.

[jlr]

THANK YOU VERY MUCH!  THIS WAS EXACTLY WHAT I NEEDED TO DO!!!

[sasavienne]

That is stunning. Thank you Alan. A truly useful function. 👍
🌟 🌟 🌟 🌟 🌟

[laveracrawley]

This was great! After watching many other videos that just confused me, I was finally able to combine multiple excel sheets from your instructions. Some of my data across sheets were redundant so I thought that after appending them (combining them together) I'd have to go through and manually remove duplicates. To my surprise, either there weren't any duplicates to start (rare) with OR this process removed the duplicates, saving me from a lot of tedious work. Superb and many thanks!

[isciamcdonald]

I went through so many videos on Power Pivots, and then I find this one, in a couple hours, I get to build a beautiful Power Pivot Table. Thank you so much !!!

[ektadhyani]

This is exactly what i needed. It takes me 2 hours to consolidate sheets on daily basis. Thank You so much. This is so easy and time saving.

[RafaelCostacurta]

So great, i've been trying to this sheets appending for weeks.... this tip will help me a lot a lot. thanks

[CanadianImpaler]

This was one of the most useful excel videos I have ever seen in my 8 years as a finance professional! Thank you!

[ann-plst]

Thank you Alan. It's been very helpful. Greetings from France.

[chriss]

Exactly what I was looking for! Thx a lot!

[paintnknit]

Subscribed and liked. Thank you so much for a video I needed for work!

[mamatkebab]

Thank you. I learned a lot from this. From new raw data that I need to amend until I get what I want from huge multiple of worksheets. Combined and pivot has been made my life easier.. Head up, buddy!!!!

[pedrocrispim]

Thank you. You saved my life. Many, many thanks
Obrigado. Salvaste a minha vida. Muito, muito obrigado

[mikevanoirschot]

Brilliant! Exactly what I was looking for. Thank you.

[Chef-]

what a godsend..been wracking brains how to achieve this. This will be fantastic for our work with multiple users workbooks. Massive thanks

[nelesound]

Thank you!!! I return to this video year after year when setting up my yearly budget. So appreciate it!
3:44 Directions Start

[mudasirabrar]

Excellent. Thank you. The only useful video I found here on the issue