Hi, Im trying to make a workbook for work but Im not too familiar with Excel.

What im trying to do is have a macro button to create a new worksheet with the same table thats on the previous worksheet but automatically change the sheet name to the ascending number (e.g 1, 2, 3) and 1 of the cells needs to automatically increase each time a new sheet is made.

Any ideas how to do this?

Sounds like a fairly straight-forward bit of vba to do something like

workbork(n).copy
workbook(n+1).rename
workbook(n+1)!$A$1 = workbook(n+1)!$A$1 + 1

or something like that.