In the attached XL 2010 macro enabled workbook, I have a listing of conference rooms for 2015. I need the dates and rooms with accompanying extensions updated to reflect 2016. Some of the room names and extensions have changed from 2015 to 2016, so I have already done the January 1 2016 part of the workbook the way I would like the rest of the workbooks to look with the correct room names and extensions. I need to create 4 workbooks each comprising 3 months of the year to reflect each quarter, so if the answer is a macro I will need to be able to run it in each of the 4 workbooks. The format also needs to remain constant across all for workbooks.