Hi I am in need of help:-

What I have:-
Over 400 spreadsheets and increasing, all of which have 24 columns and the
first row being a header row naming these columns, they all have different
amount of rows.

What I'd like to have:-
Another sheet with five columns. 1st column listing the 400 odd spreadsheets
by filename, in the next column I'd like to list the max value from a given
column from the spreadsheet listed in column A, the next 3 columns would do
the same, listing the max value from a column in the sheet listed in column
A.
As you can see this would involve 1600 or more cells (not including column
A) that I'd rather not fill manually. I'd be happy to fill the first column
listing the 400 other files.

Any ideas welcome.