Use multiple workbooks to one database with linking tables

[Franky27]

I'm thinking (and trying) to manage the following.

Working with Excel 2007

I have a directory with many workbooks wth same fields (every month a new workbook is added).
These workbooks containing about 5000 rows (all workbooks together can get over 100000 rows)

I want to make pivot tables from out of these Workbooks (merged data). Also I want to link some values out of this workbook field to another tables.

Simple this is what it looks like. (Example)

In one directory there are the following workbooks

Workbook 1
Date - Company - Number
11-11 - 2 - 23
11-11 - 2 - 22
11-12 - 1 - 12
11-12 - 2 - 13

Workbook 2
Date - Company - Number
12-10 - 1 - 23
12-10 - 1 - 22
12-10 - 1 - 12
12-10 - 2 - 13

In an other directory there is a workbook "Company"

Company.xlsx

Num - Comp Name
1 - Company A
2 - Company B

Finally I want to make pivot table out of the data like below:

Date - Company - Number
11-11 - Company B - 23
11-11 - Company B - 22
11-12 - Company A - 12
11-12 - Company B - 13
12-10 - Company A - 23
12-10 - Company A - 22
12-10 - Company A - 12
12-10 - Company B - 13

Anyone?