Need to set rows to repeat for all work sheets and add border to the last row

Hello Expert,

I need a quick help from you guys.

So, i have already made a macro that create multiple tabs from the Master 1 tab and does some formatting and totaling stuff. I am missing on 2 last points now.

1. The last Total row in each tab is not getting a border. I need them to have a Border.
2. I want all the tabs to have Top 6 rows to be repeated on the second page when printed.

Please note that everytime, the number of rows for each tab will change and number of tabs also changes.

I am attaching my current macro and a sample macro ran file. Thanks a bunch in advance. You Rock..

Regards