Automatic Update of Multiple Worksheets to Master Worksheet

[Nikyshah]

Hi there,

I am working with one of financial company. And we have few Trade names and each Trade names there is one worksheet. We want every employee work with assign Trade Name worksheet and later all worksheet data should be automatically update into Master worksheet.
My Master WorkSheet has - Trade Name, Client Name, Cottages model, Appraised Value, MTG Approval Amount, Final MTG fields and each worksheet name as Trade Name and having all same columns. Now if suppose one of the name of Trade Name is "ABC' and there is worksheet name as "ABC" if I update in ABC worksheet data it should automatically update into Master worksheet.

My Master Worksheet - (there are around 60 Trade Names means I have another 60 Worksheets)

TRADE NAME CITY PROVINCE MA Client Name Cottages Model Appraised Value MTG Approval Amount Final MTG
Subworksheet - "ABC" as TRADE NAME
N


TRADE NAME CITY PROVINCE MA Client Name Cottages Model Appraised Value MTG Approval Amount Final MTG
ABC Peterborough Ontario Alex Niky Shah Cottages 45000 45000 42000
Now, as soon I save all data from "ABC" worksheet should update into Master worksheet.
Also, no duplicates so we can also clear Master file before updating all worksheets data.

Thank you very much.

[dflak]

This is a fairly standard request. However, nobody is going to work on it without a sample workbook. It doesn't have to be huge, just enough sheets and data to get the idea across.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.