button to copy worksheet with formulas referencing previous worksheet

Hello,

I'm working on a timesheet. I would like to add a button that copies the activesheet and renames it based on cell I6 plus one day in mm dd yyyy format. Also, I would like the formulas in the newly created worksheet to reference the previous worksheet (one just copied) and lastly, I would like the tab with the current payperiod highlighted.

I have found the following but I don't know how tweak them to make them work for me.

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

I have attached a copy of the file I'm working on.

Thank you so much for all the help you can give!
Just so you know, I have spent more than 12 hours on this, I don't know where time goes when I'm playing with this stuff.