Macro-need help sorting data to other worksheets/update as new data is entered.

I need help to figure out what I am missing in my macro. I am trying to create a "Master Sheet" where I enter in the column data and after I have entered my data for each row, I can select the button which toggles the macro to run. I have it built to build new sheets as new clients are obtained. My problem is after I have a sheet that has client's data I cannot get new data to add itself below the data that is already there. I want each client's sheet to keep adding rows as more data comes in. My current macro is :

Please Login or Register  to view this content.

Data Entry Macro.xlsx

So, yes I know how to do the pivot tables and everything, but the counselors who will use these spreadsheets do not. I am trying to build this so they have a way of tracking the dollar amount of each client because we have a cap amount before we have to reauthorize their services. If a counselor goes over that cap without getting a reauth, then we do not get paid for those sessions. No money=no work I was hoping to dummy proof it a bit for them so all they have to do is enter in the master sheet their data as they see clients and then they can click on the corresponding sheets to see how much the running total is for each client. Hopefully this helps!