Let's get the nomenclature down first
a file is a workbook
a worksheet or tab or sheet is the worksheet in the file.
You need so specify the workbook(s) and also the worksheet(s) within each
workbook.

for each wb in workbooks
worksheets("sourcesheetnamehere").copy somewhere
next wb

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Satya Nanduri" wrote in message
...
I have my company inventory on 15 different excel 2003 worksheet files. Is
there any way to consolidate those file and reports for each item? I do
not
want the Pivot Table way. Because the structure of the worksheets is not
comfortable for that.

Satya Nanduri