Autofill problem or is it not autofill?

Hi All, I'm new on here and very new to using Excel 2003 so please be gentle!!!
I'm a District Nurse and have been trying to make a worksheet with my weekly visits on but am struggling.
I have a worksheet with column A having names, B addresses and C through to I with days of the week. If I see a patient on any given day I place an x in the column relevant to that day. This gives me a view of my weeks patient caseload.I call this my master sheet. I also wanted to filter out those patients I see on specific days of the week so I have copied the master sheet and created 7 more sheets that I access from the bottom row where it says sheet 1, 2 etc. I've surprisingly named these mon through to sunday! I then auto filtered out the non blank days in each of these days giving me exactly what I wanted. However, and here is my problem: when I add or delete a patient on the master sheet it doesn't update any of the mon, through to sunday sheets. Is there any way I can do this? Any help would be heartfeltly appreciated. My knowledge of Excel is very very basic but I am learning, albeit slowly.

Thanks,

Pat

Welcome

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST