Spreadsheet Formula
 

Here is the scenario

I currently have 5 tabs (worksheets) that are independent of each other.

Is there anyway to have a formula that will number each worksheet.

On worksheet 1 a cell would state: 1

On worksheet 4 a cell would state: 4

Therefore if another one was added in the middle (ie between worksheet 3 and
4) the automatic paging would increase going forward.