index page and all sheet data must be in index plus create button to add new sheet

[prakashkumar]

hi all ,
create button in sheet 1 and name as menu , if i press on button , new sheet should create and name as page 1 at the same time A1 (of page1) cell value should display in menu page.
then ,
f i press on button , new sheet should create and name as page 2 at the same time A1 (of page2) cell value should display in menu page.

OR

create button in sheet 1 and name as menu , if i press on button , new sheet should create and name as page 1 and at the same time A1 (of page1) cell value should add A1 (menu page).
and so on,,,,,,,,
if i press 5 times on button 5 sheets should be created and what ever the values entered in cell A1 of each cell must be added in A1 of menu page

my theme is to create monthly expenditure and all ll be displayed in main menu page

thanking u sir

 

[Fluff]

Duplicate to: create button to add new sheet in first sheet and calculate including newly added sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.