Ok, so my workbook has five or six worksheets in it. The main worksheet is called 'Combined', and it has all of my data in it. I then have some other worksheets that I would like to distribute this data throughout, based on what the entry in column C of my combined data says. I'd like to be able to enter new rows into 'Combined', and as I enter it have them appear in my other worksheets depending on what I put in column C. I've tried using Advanced Filter but I don't think I'm getting the criteria part right, because it's just passing everything from 'Combined' to the other worksheets. Also, will Advanced Filter allow dynamic updating?

Thanks!