Hi everyone....Here is my problem of the day I need to make a weekly schedule/calendar based on info in another sheet. I'm sure this is not the best program to do this in, however I have limited resources. Any feedback is appreciated, below I have outlined what I need it to do. Thanks in advance.

The sheet that I get the info off of looks like this:

Proj Name Proj# TimeZone Dates
Excel help 02121 Pacific 12/1-5/8

Now what I need it to do is fill in a schedule that looks like a weekly calendar, and is broken down by timezone (National, Pacific, Mountain....) Ultimately, the idea is that it would autofill appropriate dates and place according to timezone...Is that asking too much lol

Any help or resources would be appreciated....or let me know if this is not possible in Excel.

Thanks