Import multiple xml files into Calc

I have just over 1100 XML files that I need to import into a Clac spreadsheet. How do I do this?

I have used the Data–>XML source and have successfully imported 1 file, but I want them all on 1 sheet.

Is this possible? I do have an xls schema file if that can be used?