Renaming multiple worksheets from cell reference

[dozen_redroses]

Hi

I am completely new to this - my first forum post ever, so please excuse me if I have written this in the wrong place, or the answer is already in here somewhere. I have done a bit of searching, and thought that I had got the answer I needed, but just can't get it to work, so thought that I would give my exact problem.

I have created timesheets in excel with each fortnight on a different worksheet. The dates are listed in column B, with the first day of the pay period being in B13 and the last in B28. I would like the name of each worksheet to show those two dates with a - separating them. Example below. My research has suggested that I need to do this through VBA. I have tried copying posts from other people and changing the cell reference, but just can't get it to work!

Any help would be greatly appreciated.

Thanks