Combine Multiple Spreadsheets Into One in Google Sheets

Sure, you can use ChatGPT to write you a script to combine all these together, but where's the fun in that? Well, I guess prompt generation is fun. But still, this is where Google Sheets blows its competition out of the water - especially if you're still using Excel 2016 like I am!

----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 Intro
0:50 Structures
4:00 Combining the data
8:30 Combine multiple workbooks

----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[michaelsglas]

Wow this was truly helpful as I’m building out a product that incorporates multiple members to keep me updated on the status of our business. I’ve incorporated this and I must say that it work flawlessly. Every day I learn something new and I am glad that I came across your channel. Thanks again for your tutorial.

[RadoHudran]

14:07-14:33 is my favorite part of this video
That shocked realisation 🤣🤣

[conuk]

Great video thanks - as this is dynamic ie the master changes then the copy updates - is it possible to rework this so it only imports once - maybe on a button press - so it does not slow down each time a colleague changes anything in the master - but can at least make 1 / 2 copies per day?

[writhininanakedsweat]

I love you! Thank you for making my life easier lol I didn't want to be forced to learn how to use scripts to connect different spreadsheets together I just came here to say that.

[HashAliNZ]

Did you spot the uncorrected error? It takes a good eye! Let everyone know what you saw!

[GoingGreenMom]

🤯 I think you just fixed a lot of issues with a project I'm working on.

[BobMiner-us]

Excellent example and explanation. Thanks.

[AngelicaKymling]

Wow! Thank you for a really helpful video

[AshleyJenner-ontq]

Thank u very much! Because there are many people teaches how to combine 3 sheets, but no one tell them how to combine more sheets

[Polaynka_Bolgarka]

Thank you for simple explanation. You make me happy!

[mgrollins]

Thank you very much! Very easy to follow and I liked your screen casting as well🎉

[krishnatate]

Sir ur really great... Amazing teaching and tricks...
Thank you so much for very helpful video.. m big fan u sir..❤

[khunkeng]

Thank you so much, this help my life a lot better 😄

[staceyleslie]

At 7 minutes I followed how to combine sheets (which is awesome) into a master sheet & avoid the blanks....but then how can I sort the master without messing up the formulas? Exmple....then in the master I want the master sheet to always sort by dollars sold highest to lowest that it pulled from all the sheets....is that possible

[byyxzsv]

Question: Using your example at 16:02 in the video, lets say I have additional data to add to each row on this master sheet after you have combined the workbooks....each time a new sheet (month/year) is added the new data in the master sheet will not correspond to the correct row. How can this be fixed?

[uberalles]

Wow! Great tricks to cut tedious work in the end 😍

[Polaynka_Bolgarka]

Will be work to combine multiple workbooks if it have different columns?

[ddomfire]

hello! if for instance, I want to have an extra column to note what months these data were from, is there an easy way of doing it?

[kanewei]

Hi, thank you for your video, may I know how I can separate each IMPORTRANGE data by one extra row?

[soulinenguyen]

Hi, I have a question. If I edit on one of the workbook, will the combine workbook also update that edit? Thankiu