Hi,

Currently, Iam doing a very tedious and time consuming job. Please help me
out on this.

I have several Workbooks say 30+ having only one worksheet with the same
layout i.e., Heading1, Heading2, Heading3 .... in the first sheet. The
Headings starts from B8:N8 and have some headings having a drop down list to
be picked up in each row beneath that till row no. 200.

Each workbook is named differently. My requirement is that I need to collate
these information by copying and pasting in another workbook named "Total
Data" of all these 30+ workbook information one below the other (i.e., from
Workbook1: Copy/Paste B9:N200 to the Workbook named "Total Data" and from
Workbook2: Copy/Paste B9:N200 to the Workbook named "Total Data" just below
the data copied from Workbook1....... and likewise for all Workbooks in the
"Total Data".

Secondly, I also want the name of each Workbook to be captured in Column A
in the master Workbook "Total Data" accordingly.

Please note that the Workbook "Total Data" has also got the same layout as
that
of the other Workbooks.

Can you please help me out in creating a Macro to do this task.

Your timely help will be greatly appreciated.
Prashanth KR.