Good Morning!

I need some help.

I have this workbook with a total of 8 sheets.

The main sheet is called €œTRANSFERS€�
The other 8 are the named €œERROR1€� €œERROR2€�€�ERROR3€� and so on€¦

On the main sheet I have this columns

A B C D E F G
Name Date Sup Lead Manager Number Error

What I need is each time a row in filled on the main sheet; I would like it
to be copied to each sheet according to the error.

The error will be entered on ROW G whether is an error1 or error 2, I want
the row to remain on the MAIN sheet but a copy to be moved to each sheet
according to the error.

Can this be possible? I have been trying but just can make Macros work.

Any help would be appreciated. Thank you