Build Table From All Workbooks In a Directory

I am very limited in my excel knowledge.

What I would like to do is build a singular workbook that gathers its data from all of the workbooks in a particular director.

Within the structure, the workbook being created will be one above the target directory, the target directory is called "2011".

Essentially I would like to automatically pull the name of the workbook, and some of the data from the file. Here is what I have been doing:

AAI DrainTrac 2011.xls

The above is the best dynamic version I could do, but I cannot keep it up to date with time I have.

Here is a sample of the workbook data will be pulled from.


FAMILY DOLLAR DIST. CTR#10 MEA.xls

Any help is greatly appreciated!

Can anyone help?