Copying sections from one sheet to another. Keeping format and data for drop down menu cells

[rcicconetti]

This is for a scheduling program I am building on Excel.

I am trying to copy 7 areas (daily schedules for a week) to a new sheet. I want the sheet to be created using the name (i.e. "Week of Oct5") found in "T3:U3" on the main schedule building sheet ("Scheduling Assistant 1.0".) Each week the scheduler will use the main scheduling sheet to adjust the date and staffing. I want the macro to create a new sheet each time it is run.

Tricky Part:

The original areas have content that have been selected from drop down boxes on "Scheduling Assistant 1.0." Is there a way of pasting that will not only maintain the format of the cells, but also the ability to select the contents in the new sheet? (In order to make schedule changes)

The 7 areas for the daily schedule are as follows:
"X3:AC52"
"AE3:AJ52"
"AL3:AQ52"
"AS3:AX52"
"AA59:AF111"
"AH59:AM111"
"AO59:AT111"

They can be pasted on the new sheet respectively as follows:
A1
H1
O1
V1
AC1
AJ1
AQ1

Print areas for this new sheet should be set to the following as to print one page for each day. (Portrait, Fit to Page)

Page1 A1:F50
Page2 H1:M50
Page3 O1:T50
Page4 V1:AA50
Page5 AC1:AH50
Page6 AJ1:AO50
Page7 AQ1:AV50

I attempted to do this by recording a macro, but I have had no luck.

Any help would be greatly appreciated!!

Thanks!
Rich