Copy rows to another sheet on condtion

As attached, the excel sheet has 9 sheets. Each sheet has 10 columns (A to J).

I want a macro to do the following.

It should read sheet 1 to 8 and copy whole row if column G has a value, and paste into Sheet 9. I have renamed the sheet 9 as “consolidated”.

It would be great to put a button then I can hit it whenever update required.

Dear Naflas,

Try the attached workbook.

I hope it helps,

Mohammad

Hi.. Mohd9876 that's wonderful.
I require the same but having only one worksheet.
data has to copy from sheet1 to sheet2...that's it

Could you please help me out?

try this workbook, i modified a little in the code