Merge multiple sheets to main one

Good morning,

I have 4 sheet that have all the same sections (Q1,Q2,Q3, Q4). I want to merge all the data into 1 main sheet.

I need the macro to find the specific row of texte (Exp: Q1), then copy the rows that have data into the main one without overwrighting one over the other.

My problem is that not all sheets have the same amount of used rows.

I have attached a sample of the document.

Thank you for your help!

Eric

Badly structured data....

Please Login or Register  to view this content.

Thanks it works your a champ.

Any suggetions in order to fix the badly structured data ?

I would have only one sheet for data entry, no merged cell and it should be tabulated.
That makes things very much easier to extract data for printing/viewing purpose with Filter/Pivot/SQL etc.

Even if you need to separate the data entry sheet, it should not contain any blank row(s)/column(s) within data area.

Just my suggestion...