Consolidate Dynamic Range from two worksheets into one Master Sheet

Dear All,

I hope you can help solve this.

I have three worksheets, (i) Master (ii) Jan (iii) Feb worksheets all in the same workbook.

The range in Both Sheets "Jan" and "Feb" are dynamically named but have fixed column but varying rows. The dynamic names are "Jan" and "Feb" respectively.

Is there a way to copy and paste or stack all data from sheets Jan and Feb into the Master Sheet i.e. Jan pasted first and then Feb pasted from the last row following Jan.

I would really appreciate it.

Regards

Laylow

Dear Pepe,

Thanks for the response, this is a brilliant Addin, but not doing what I really want.

I appreciate your time.

Regards

Laylow

Thanks Trebor06,

I will try this and get back to you soon, hopping on a flight now please don't be upset if response is a little late.

Regards

Laylow

Dear Robert,

This was magic thanks a bunch. Please accept my apologies for the very late response. I was once heavily into VBA programing some years back but now work as an airline pilot hence why I disappeared for a while without a response. I was only trying to tap into my left over knowledge of VBA hence why I needed some help. Still have so much love for programming!

The code works fine BUT it copies all named ranges within the worksheet.

(i) I want to be able to specify within the code the sheet names e.g. “Jan” or “Feb” or indeed the two range names respectively in that order that I want copied over to the “Master” sheet. I want "Jan" to be posted first before "Feb".



Best Regards

Laylow

Dear Roberts,

This is magic and absolutely brilliant!

Felt like I won the lottery to see the code work so nicely!

I would have sent you a boarding pass but I fly a little west of your continent.

You're the Best.

Regards

Laylow