Once an advanced filter has been set up in excel, is it possible to refresh
the results of the filter if the source data changes?

More background:
I'm creating a tool for users who are not savvy with excel. They enter
values against a list of names (A,B,C or D and 1,2,3 or 4). On another
worksheet I want the names to be displayed in a grid: everyone with an A1
goes into the top left of the grid, A2 next box to the right, etc.then
B1,B2... in the next row of the grid. I'm trying to do this using advanced
filters. The filters work when I set them up, but I don't know how to refresh
the results. EG, for the user, when they go back to change a value against
the original list, the name should move from one box in the grid to another.