Copy a range of cells to another worksheet

Hi, I have a workbook containing multiple worksheets. I enter data manually in all the worksheets except one say worksheet "X". My requirement is to populate a range of cell in "X" from other worksheets based on a condition. The condition is " If a column G in other worksheets contains value 'Test', then copy range A:F to range A:F of worksheet "X". I should also be able to know that the cells that are copied are from which worksheet."

Any help will be appreciated in this context.

Thanks...