Excel Macro to increment a number by 1 needed

Hi. I need some one to code and give me a MS-Excel spreadsheet so that each time I click to open a new SHEET, a specific cell, i.e. cell A1 has a number in it which is 1 greater than the number on its parent sheet. i.e. Sheet1 in Cell A1 there should be a number 1. When I go to Sheet 2, Cell A1 in Sheet 2 should say 2. I want all numbers so that its always a 6 digit figure i.e. instead of 1 it says 000001. The cell should be read only. I am using MS-Excel 2007. ## Deliverables [login to view URL] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.