Copy & Paste Data from Selected Worksheets to One Worksheet

Hi there,

I am new to the forum and not good with VBA coding at all. I have a workbook with 3 raw database worksheets that get updated every week. From this I have set it so that 6 other worksheets combine and receive the relevant data in terms of specific categories. I have a final worksheet detailed Report 2 in which I would like to display the 6 worksheet data sets in there respective categories.

The 6 worksheets have multiple blank spaces and therefore I need these removed in the summary. I also would like the tables in the final Report 2 to be one cell below each other (6 tables with headings of respective worksheets).

I would be greatly appreciated if someone could help me out with this?

Thanks.