I am new to this thread so I thank you in advance for all your help. I have a 16 week master schedule (calendar style ) that I have broken up into three week increments on separate sheets in the master workbook i.e wk 1-3, wk 2-4, etc.. I am in construction and in charge of building houses. So the schedule is the same for each house however each lot has its own three week rotating schedule that I send out every week depending on where the house is. In another workbook I have a page for each lot, what I would like to be able to do is simply type a 1 when the house is on the wk 1-3 schedule and have it autopopulate or copy the entire sheet from the master workbook and then same could be said if I typed 2 it would autopopulate wk 2-4 etc. I am not an expert in excel thus explains the problems I am having. I hope you will be able to tell me what function to use in order to properly conduct this correctly. Thank you again.