pulling data from multiple workbooks

Hi everyone. I am looking for a way to pull data from multiple workbooks, all of which are formatted the same way.
Currently I am drawing data from This Workbook and populating a worksheet (called 'major') with entries that have values over 40 in the H column. This is what the code looks like

Please Login or Register  to view this content.

Can anyone help me out, so instead of just specifying this workbook to pull data from, I can pull data from this workbook and another 2 workbooks at the same time?

Thank you very much for your time

@rlowe,

here is my solution , hope this helps.

Try this new version , that supports multiple folders.

Try this file,

Comments :

Your source is xls files, so i did some changes to handle xls and xlsx files.

In the condition cell your condition would be always referring to the 1st row, so your condition would be H1 >= 40000

Leave a space after H1 and then >= (no space between > and = , make sure that = goes last as the condition is greater or equal if you notice in the filter options).

After this leave a space and then the value 40000.

* The folder list should be separated by "," like this :

C:\my folder1,c:\my folder2,c:\my folder3