VBA code to import data from multiple worksheets in the same file

[WHATSXL]

My department runs a daily report that all save in the same file. The reports are the exact format everyday and all data is in the same cells on each worksheet.

What I am looking for is a VBA code that would allow me to quickly import specific data from each worksheet onto another worksheet. I would like the code to be able to reference a list of file names located in a column.

For example:

names of the files located in - range A1:A100
of worksheet - DataCollector.xlsm
files located in - C:\Users\Reports
import data from cells - A10, B15, C20
into cells - D2, E2, F2
on DataCollector.xlsm

Sorry if this formatting is ridiculous. I have found many examples online that are close to what I need but I have not been able to successfully alter them yet.

If I could get a code that makes those exact parameters work, then I would be able to save the day at work.

[mike7952]

Do you have sample workbooks with your expected results, and a sample of the workbook your wanting to import?

[WHATSXL]

I believe these worksheets should represent the problem well.

In the Worksheet DataCollector, I have described the problem and the only solution that I have been able to come up with.

Thank you for your time.

[nilem]

Hi WHATSXL,
maybe so

Please Login or Register  to view this content.

[mike7952]

give this a try

Please Login or Register  to view this content.

[WHATSXL]

Wow. Perfecto. Thank you very much sir.

[WHATSXL]

Okay. quick clarification.

I tried Nilem's solution and it worked. When I posted, Mike's was there.
Haven't tried it yet, but Nilem's works nicely.
Will play with Make's solution more but making thread as solved.
Thanks guys. Very impressive forum here.