If Column E is Y then copy entire line to a different tab in the spreadsheet

[jock1967]

I am trying to automate a process. I have spreadsheet with 5 tabs, 4 of which have data entered into them. Once this data is entered I want Excel to automatically when a Y is entered into column E (Margin Sheet) then the entire row is copied to the tab labelled Margin Sheets (each row to go into the next available line on this tab). This process needs to happen for all 4 tabs which have data entered into them.

Does anyone know if this is even possible? If so I would really appreciate the help! It will score me some points with the Wife.......

I have attached an example spreadsheet which may help you to understand

Thanks

Scott