ISSUE #1: I want to take cells from the master sheet 1 and filter data to put into separate sheets. I've been able to do the advanced filter for each column in the master, but not for specific fields within the master. In the master, I want the List Range only to include columns A, B, H, I, and G (in that order). I keep getting the "database or table range is not valid" error. I don't get the error when I use the advanced filter to set the List Range for all columns (Master!$A$1:$M$500). Is this possible?

ISSUE #2: When I get the advanced filter to run fine, I want to have those secondary sheets (3 thru 6) to auto update each time a new record is added or an existing one is changed in the Master that meet the same criteria. I have 4 separate sheets drawing data from the master. Each sheet represents a filter by a person's name so they only see their assigned cases with specific columns from the master, but also with the ability for each user to add custom columns on their respective sheets without disrupting the ability to auto update their filter. Any help here is greatly appreciated.

I'm also more than willing to pay for points, but we are a federal government agency and would need a W-9 to process the transaction. I appreciate everyone's time!