Mutiple spreadsheets into 1 table

[BlueAngel]

I have around 10,000 Lotus spreadsheets that I would like to copy data out of all of them and put it into one Excel spreadsheet. For example take B5 out of each lotus sheet and put it in A1, A2, A3 etc, etc. up to A10,000
Does any one know an easy way to do that?
Or is there somthing else I should be using to get all my spreadsheets into one table?
I would really apreceate any help
Thanks,
Paul

[BlueAngel]

Does Excel have a function that does anything close to that?