Formatting multiple copied sheets in macro

[swilliams]

I have a file with a macro that creates a new sheet named New Record. We use this new sheet to enter data and then rename the sheet 2010Q1, 2010Q2 etc to represent the year and current quarter. I also have a macro that is capable of coping anyone of the sheets and/or multiple sheets (depending on which tab I want to copy at that time) and exports them to new workbook. The macro reformats the first sheet but not multiple sheets. How can I get it to format the additional sheets selected after the first sheet? Below is what I have so far:

Thanks,