Excel macro button

[rameshca550]

I will enter data in a row I select that row when I click the macro button the row should sit on next sheet first row and should increment daily
E.g.
name, service_no, load, deposit, section
When the details are entered in the first sheet and submit button clicked the load sheet will have to update with data given in the first sheet as well as deposit sheet section sheet area sheet and load sheet section sheet
I need to maintain hunge amount of sheets
I have columns like phase section category type area

 

[My Aswer Is This]

When you select a row and then click the submit button you want this row copied into the next sheets first empty row is that what you want?

What is the name of the "next sheet"

And what column will always have data?

 

[rameshca550]

Always column name will be the sheet example area

 

[My Aswer Is This]

Do not understand your answer and you did not answer these questions:

What is the name of the "next sheet"

And what column will always have data?

 

[rameshca550]

I have
Sl.no deposit amount service no and category and area as columns I have sheets of category deposit and area when I entered the details in first sheet the corresponding sheets that is area deposit and category sheets should be updated with same details in raw data sheet
E.g.
Raw sheet
Area deposit amount category service n0
Asia. 10000. 2. 22222
On followinng sheets
When the details filled in the raw sheet it should automatically update the corresponding sheets of area deposit amount service no
With all details in raw sheet if any thing Misses in the raw sheet column it the corresponding sheet need not get all details from raw sheet
E.g.
If I didn't entered sd amount in raw sheet
Then the sd sheet should not get any of the details from raw sheet leaving other columns and others sheets getting data

 

[rameshca550]

Area will we text and all are numbers