Macro to save a cell value from multiple worksheets

[naga]

hello all,

I have a excel file in which it contains 11 worksheets.
It has one master sheet and 10 customer sheets.
This file is used for my finance company.
In the customer worksheet I have the following fields,
- Account number
- Name
- Loan amount
- Paid
- Pending

I need to copy the values from all the 10 sheets to the master sheet.
- Ac number - Name - Paid - Pending
Row one should contain details of ac number 1 and row 2 should contain details of ac number 2 and so on.

How to make it possible.

Kindly help me.

Sample file attached.

[tigeravatar]

naga,

Attached is a modified version of your posted workbook.
In the 'MASTER' sheet, there is a button labelled "Update"
Clicking on that button will run the following code:

Please Login or Register  to view this content.

Does that work for you?

[naga]

Wow.
This is what I was looking exactly.
Thank you so much for the immediate help.
So kind of you Tiger.

[JOHN H. DAVIS]

FWIW

Please Login or Register  to view this content.