Use Indirect? Pull data from multiple WB's into Consolidating WS

[dawnmau]

Hi all Guru's!
Background: I have a number of WorkBooks in a folder that follow same template. Each WorkBook represents a "Project" and is a separate file with multiple worksheets

I have a WorkBook that is used to keep track of ALL Projects called the "Indirect formula".

I am trying to pull data from the "New Monitoring Value Datasheet" into a file called "Indirect formula (for purposes of your assistance) into columns P thru S

I tried the following formula but it's not working and I think I need a fresh pair of eyes.
=IF(ISERROR(INDIRECT($N5&P$1)),0,INDIRECT($N5&P$1))

I am attaching the Indirect formula file as well as 2 Project Files

Would I be able to create a macro to do the same thing for the "Summary" page?

Thanks so much for your help!

[dawnmau]

Figured out what the problem was, Apparently you cannot have it pointed to a specific directory. It needs to be the file name as it is only going to look at whatever file is opened. Now to see if there is a macro that will allow me to open all the files in a specific folder, get the data, save the data, and then close the files.