Combine Several Worksheets Into One within a workbook

[johnthebuilder]

Hi,

I need to combined the information from 2 sheets onto a third sheet. 'Kitchen + 'Bathroom to 'Combined
The header needs to appear at the top.

I have removed all the extra sheets from the example I have attached as they are static and don't change. Also taken out the formula's to keep the example simple.

The data on each sheet can be up to 10,000 lines so I don't want to copy/paste every time I do it.

I have tried to use code found on line but can't seem to get it working.

I am using 2010.

Thanks