New to codes. Need help - Auto fill across worksheets based on name

[showzow420]

Hello,

I've attached a sample of my worksheet below with fake names and data. I'm looking to create a caseload list for each "Service Coordinator" on separate tabs/sheets. I listed out the Service Coordinators under the tab "SC," as well as created a tab for each of them.

Under the "Master" tab, I inputted formulas under the "Six Month Reviews" column, "LEA Due date," and "TPC Due date" columns. However, all of the other data was manually inputted.

My hope is that under the "Master" tab I can update the other columns and have it automatically update on each Service Coordinator's spreadsheet. In addition, I'd like to be able to add to a Service Coordinator's case load. For example: Lisa Frank has 2 cases - Captain Marvel and Black Panther; However I'd like to add a third case by creating another row with Lisa Frank as the service coordinator and another client's info listed after that.

I've been playing around with Macros and found a few youtube tutorials that have walked me through the formulas. However, I keep having a hard time translating what they're using to the data I'm using. It could be because I have formulas in some of my columns as well.

Can somebody help me figure out the right Macro for this spread sheet? I understand it may be challenging, but I'd greatly appreciate it. Please let me know if you need any additional information from me!

Thank you

[Mumps1]

Is there any reason to have all the blank rows between each case? After you enter the data in columns A to E, will that data ever be modified or does it remain constant? Are the Enrollment_ID's in column B unique values, in other words each ID appears only once in column B?

[showzow420]

Yes, data will be modified in each column. Columns O and P are calculated based off of column E. Column L is calculated based on Column K. Both column K and E can change.

The Enrollment ID's are randomly generated and do not duplicate. They are actually a combination of letters and numbers. Ex: H5326-01 that are randomly assigned to each client.

Let me know if there's anything else you may need!
Thank you

[sintek]

This is a perfect scenario for Userform Interface...Lot of work, but well worth it...
Check out torachan posts...he loves creating these...

[Mumps1]

How are the ID's randomly generated? Are you using a macro to generate the ID's? If you are using a macro, please post the code. I understand that the data in the columns will be modified, but will the data in columns A to E (Service_Coordinator, Enrollment_ID, Last_Name, First_Name, Date_of_Birth) ever be modified once entered or does it remain constant? In other words, will only the columns from F to P be modified? Also, do you need all the blank rows between each case? For example, row 3 is blank, rows 5 to 13 are blank, etc. Do you need these blank rows?