Combine more than two Calc files into a single master file

[ds.sundar]

Hi guys

I have to combine some 10 to 20 excel file into a single master file. Each and every file has some 20 to 30 spreedsheets. Can anybody give me a macro to do this. i am new to Oopen office and also to programming. I am not so much expert.

Now i open each and every file and copy paste it into a newly created master file.
After some search in the net i got a link http://www.ooomacros.org/user.php to combine file. it is exactly as same as i want. but it combines only doc file and not the Excel spreedsheets.

So please anybody help me by providing a macro to combine more than two file in a single click

Thank You very much in advance.

SUNDAR