Excel 2007 : Fill cells with reference

[berlini]

Hi guys,

i need to fill cells B1:B156 with a specific reference
Let me explain:

i have an excel sheet with a a list of 156 project:
Column A contains the project ID (1,2,3,...,156)

on the other hand, i have 156 other excel files containing project specific information (the layout is identical but only the content differ from file to file) and located in one folder.


I want that the cells in column (B) grabs data from a specified cell within the respective project-excelfile:

in cell B1 get data from cell 3 from excel file of project 1

in cell B2 get data from cell 3 from excel file of project 2

in cell B3 get data from cell 3 from excel file of project 3

.
.
.
in cell B156 get data from cell 3 from excel file of project 156

So is it possible that the filename in the reference automatically incerements when I auto fill the cells B1:B156