Find word on Sheet1 move all adjacent column values to sheet2

 feeders -
I have a list of accounts and information on items inside the accounts along with the account owner.
It goes like this, A= account number, B-J = item information, K = owner name
A certain owner may own account 1, 17, 34, 50 and 102. I need to make a sheet for each owner that displays only the information on each account that the certain owner owns. Can anyone help?

1 reply

OH, also, each account will frequently be added to (by inserting rows) and I would like the owner sheets to automatically display the new information.