Ok, this is the setup, worksheet1 is my master list with tons of info; one column named 'Approvers' is populated with names. Would like to make other worksheets 2, 3 etc. that only contain the rows that have corresponding 'Approver'; as i make changes or add rows with data the worksheet will check for the Approver name and automatically copy that row to the appropriate worksheet. Otherwise I'll be stuck making updates to multiple worksheets whenever there's a change.
I'm sure there's a way to do this, thank you soooo much for your help!