Trying to make a recorded macro work properly

Hello everyone

Although I've been a member for a while, this is my first post.

This is my problem. I have recorded a macro to pull data from an Excel worksheet into a pivot table on a new worksheet with defined formatting and layout.
I also want the macro to rename the tabs of the data sheet and pivot table sheet. I want the macro to be able to be run no matter what the data sheet name be, "Sheet1", "Data", etc, it's only the 'new' name that is important, in this instance I want them to be titled, "Labour Hours" for the data sheet and "Hours Pivot" for the pivot.

I have seen many comments here about wrapping code into tags, but I have no idea what that is so rather than make the same error, can someone tell me how to upload my recorded code. I have attached the data sheet to begin with.

Any help you can give would be hugely appreciated.

Many thanks in advance.

Nick