Copy rows from multiple sheets based on data

[Kaz09]

I have a workbook with several name sheets. I would like to copy and paste rows from the two master sheets names Sales and Accounts to the relevant names sheets based on the drop down list text in column J. Eg. If column J equals Coral on the Sales or Accounts Master sheets, copy the row automatically to named sheet Coral. If any changes are then made to the original sheets Sales and Accounts, I need the changes to be made against the Coral's sheet. I am currently using the code below which works for one sheet but I do not know how to extend it for multiple sheets i.e. Sales and Accounts.

=FILTER(Sales!A:N,Sales!J:J="Coral")

Thanks,
Karen

 

[Fluff]

What version of Excel are you using, as 2013 doesn't have the filter function?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)