VBA code to consolidate data tabs

[Matrix007]

Hello
I need a VBA code to consolidate data from numerous tabs into one. The format of the data tabs remain the same.
See the attached example where sales from different departments need to be copied across to the consolidated tab.
Thanking you in advance for your help.

https://photos.google.com/share/AF1...?key=UWpoR195WHBVRkRnUWFSVDkyZVNMYWREQmhNOC1n

 

[Matrix007]

Thank you Robert @Trebor76.
Fantastic work!

 

[Trebor76]

No problem. I'm glad we got it working as expected

 

[Make it work]

Thank you Robert for the code and the welcome. This worked wonderfully. Glad to find this platform. I'll make sure next time i start a new trend.

Cheers

 

[Trebor76]

Thanks for the feedback

 

[Matrix007]

Thank you Robert