You say:

As I receive the reports by mail, the 60 monthly reports are placed in a

dedicated folder : :MReports_July09

With the month and year in the name of this "dedicated" folder, I take it
that the folder changes for each month. Is that correct?

Will there ever be any files (workbooks, etc) in that folder that are not
the monthly reports that the macro should work with?

This "Consolidated Worksheet" into which you want to "merge" data, is that a
separate workbook? If so, in what folder will it be located?

You say you want the data from the 53rd tab of each monthly report "merged"
into the "Consolidated_DB? What is the name of this 53rd worksheet? What
do mean when you say "merge"? Do you want a simple copy/paste done? Or is
it more involved?

In item 2) of your post, you mention "the revised submission" and how it
should be merged. Do you want a search done for each Location Code, and if
found in the Consolidated_DB, delete it from the Consolidated_DB and copy
over the new one? Do you want this done one at a time or can the code
simply delete all entries having that Location Code? And how will the code
know that this one monthly report is a revised submission and not an initial
monthly report?

As you answer these questions, remember that no one reading your
post works in your office nor knows anything about your office. Please use
generic terminology whenever possible. HTH Otto

"Ananth" wrote in message
...


I receive data from warehouse in charge in excel which has 52 tabs of
information. Key information is captured in the 53rd Tab called
"Database"
This database has 500 rows and 26 Columns of Information. Has a header at
A1
to Z1.

Column A represents Location Code (5 digit : example : "US001")

This is a monthly report submitted by Global Managers at 60 locations
This
is a uniform report and the Database Tab is password protected.

As I receive the reports by mail, the 60 monthly reports are placed in a
dedicated folder : :MReports_July09

I sitting at WhqHQ, would merge all the database in a Consolidated
Worksheet
manually and start analyzing., prepare reports which are all standardized.

1) I require a Merge Macro which will consolidate the "DATABASE" into one
Consolidated_DB,

2) As and when I receive the revised submission from a LOCATION, the macro
should merge the revised DATABASE and delete the old one (Key : Location
Code
in Column "A")

Any help is appreciated.