Combining multiple sheets into one, but dynamic

[picklefactory]

Hi folks
Struggling to find what I need and not sure best approach (VBA or formula) and hoping for some assistance please.
I have multiple sheets with the same number of columns on each and also the same headers, so identical format. Each of these sheets will expand as new rows of data are added, but not at the same rate, the data additions to each sheet are individual, but I'd like to have a 'Master' sheet that will combine every populated row from each sheet into one big list and keep itself updated as each sheet expands.
A. Is that possible?
B. Would VBA or some sort of Index/Match be most suitable?
C. How the heck do I get started??
Thanks

 

[sandy666]

Use PowerQuery and Append feature

 

[picklefactory]

Thanks Sandy, never used it yet, I'll install and have a dabble

 

[sandy666]

For Excel 2010 and 2013 this is add-in from MS site
for higher version PQ is built-in

edit:
PQ doesn't support Mac

 

[picklefactory]

Oooh... I like that. Not sure what I'm doing with it yet, but I've managed to get it somewhere near already. Why haven't I played with this before???
Thanks again Sandy, I think I'll suss it in a bit, if not, I'll be back.

 

[picklefactory]

Works a treat. Few niggles to iron out, but essentially done. Just a few weird duplication issues I haven't fathomed yet.
Thanks again Sandy

 

[sandy666]

You are welcome

Any question? Come back

Have a nice day

 

[SpillerBD]

Oooh... I like that.

As always MikeGirvin has some videos on using "PowerQuery" now referred to as Get And Transform.
There is probably the first book, "M is for (Data) Monkey"
and the more recent. "Collect, Combine, and Transform Data Using Power Query in Excel and Power BI"

 

[sandy666]

The best start is from MS site and next any books or videos

I've never read these books from above and maybe I watched 2-3 videos