Creating a date stamp that then gets added to a diffrent worksheet

*SOLVED*

Hello,
I've been able to do a lot of self-help and have a little knowledge of vba/general programming. However I'm stumped on this.

Attached is a tracker that I've put together to show progress on a critical path. Although it's not complete, the bit I'm stuck on is adding a time stamp =today() into a different worksheet, the previous column along but the same row i.e. if cell F5 gets populated with a "1" on the "Promotion" worksheet, it then adds a timestamp to the worksheet called "Promotion Performance" in cell E5. I have managed to get this working for the column F but not for any of the others.

If you look at the code, its defining the range I'm struggling with. The spreadsheet might get more columns added to it as time goes by and so I'd ideally like the code to be dynamic enough to cope with it (although I don't mind changing things if not).

It does do some other things like add a comment to the cell and also locks itself but this works fine throughout the spreadsheet. Sorry if the code is all over the place - it might not be the most logical way of doing something

Can you help? Thanks in advance

Phil