Hello, can someone point me in the right direction or give me an example code. Here is what im trying to do, I have several workbooks that I have to print each week. I wanted to move the sheets to one workbook and have each sheet print in a sequence.

For instance I have sheet1 print One time and then move to sheet2 and it has vba to print 5sheets but changes the dates on each sheet then move to sheet 3 and it has vbato change dates on each print. How would I go about this?