Copy rows of data from multiple worksheets to based on column equalling YES

[Kaz09]

I have a workbook that I'm automating to achieve the following:

A. Updating Washlist Tab:

Objective: Copy rows of data from both the Vauxhall and Peugeot sheets to the "Washlist" tab where column G equals "YES". Any changes made to the original sheets should be reflected in the "Washlist" tab. I initially attempted using VBA, which partially succeeded, until I started adding names to column J and then it just kept breaking.

B. Updating Named Tabs:

Objective: Copy rows of data from both the Vauxhall and Peugeot sheets to relevant named tabs where column J equals a specific name. For example, if column J equals "Coral", copy the row to a sheet called "Coral". This process is independent of whether column G equals "YES". Someone suggested this could be done using Filter and VSTACK but I have little to no knowledge and could not get it working.

EG: If, for instance, row 2 on the Vauxhall tab contains data in columns A to E, and "Coral" is entered in column J, copy the row to a sheet named "Coral". If the same row on the Vauxhall sheet is later updated with "YES" in column G, copy the row to the "Washlist" tab and update the corresponding row on the "Coral" sheet to reflect the change in column G.

Any help would be greatly appreciated.

Thanks,
Karen