Copy Data from 100 workbooks with cells into a master workbooks

Hi buddy,

I wanted to have a VBA code/function that can copy data from 100 workbooks (or less or more) into a master workbook as follows:

cell "A1" to the column A
cell "B1" to the column B
file name to the column C

would anybody help?

Many thanks!

many thanks!

Hi patel45,

Thanks for your help. I want to modify your code that the destination is pastespecial "value" only. Would you modify it for me. Thanks!