Button to automatically change linked cells
 

Hi all,

I have a questionaire that populates the data on the next sheet (Sheet2). I
want to create a button that will change the linked cells automatically so
the next person to fill it in will be captured on a separate sheet (Sheet3,
then Sheet4 and so on). I have no idea where to start on this as I am a
numpty when it comes to code.

Hope you can help
Have a great Xmas all!!!

Thanks

Michael.