Hi,

*

I'm a complete noob to VBA and am starting off needing some assistance with, what seems to a noob anyway, a fairly complex problem.

*

I need to pull data from a specific row from of a specific sheet from many files in a folder onto a master spreadsheet for each of many workbooks in a file, and list (each of the "row 3's") on subsequent rows in the master file.

The folder containing all of the 'child' files is added to daily with more 'child' files.

I need the master file to continue to list all the new data as the file with multiple workbooks receives new workbooks added to it.

There are multiple types of files saved in this shared folder... .xls .xlsm .xlsx... and I need to pull the data from each of these different file types...

*

I'd prefer it to not have to open each file, as there are several hundered within the folder.

*

Somewhat like this...

file1

********* Column** Column

Row** Cheese** Meat

Row** Feta******* Chicken

*

File 2

******* Column** Column

Row Cheese** Meat

******* Bleu******* Beef

*

To look like this...

*

Master File

********** Column** Column

Row*** Cheese** Meat

Row*** Feta******* Chicken

Row*** Bleu******* Beef

*

Each of the sheet names are the same within the files.

*

I'd be thankful for any help I can get as again, I'm a complete NOOB -Thanks, and apologies in advance for anything that doesn't make sense!

*