Importing external data from internal service call into excel

I have internal service call which will generate xml data in excel format when I try to import into excel(data – from web) it is recognizing only first sheet out of 7. want to import all 7 sheets of data into excel with proper sheet have it in the xml service output

If I save same service output and open it in excel I could see all 7 sheets. I want to automate the manual step and ability to pass product id as an argument during refresh from excel

Please advise what is the best approach to resolve this

Thank so much for your time Service request URL passing product id

http://ift.tt/1Fr634n

sample condensed service output looks like this

<?xml version="1.0" encoding="utf-8"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ms="urn:ms" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:xsi="http://ift.tt/ra1lAU">
  <ss:Styles>
    <Parammeters_Copy>
      <Params xmlns="">
        <xsltcode>Report</xsltcode>
        <Business_ID>P_000477</Business_ID>
      </Params>
      <Cutoff_Date1>20141126</Cutoff_Date1>
    </Parammeters_Copy>
    <Style ss:ID="Default" ss:Name="Normal">
      <Alignment ss:Vertical="Bottom" />
      <Borders />
      <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" />
      <Interior />
      <NumberFormat />
      <Protection />
    </Style>
   </ss:Styles>
  <Worksheet ss:Name="Offer Structure Table">
    <Table>
      <Row ss:AutoFitHeight="0" ss:Height="50">
      </Row>
      </Table>
 </Worksheet>
  <Worksheet ss:Name="Offer Rules">
    <Table>
    </Table>

  </Worksheet>
  <Worksheet ss:Name="Offer Attribution">
  </Worksheet>
  <Worksheet ss:Name="Offer Data Extract">
    <Table>

    </Table>

  </Worksheet>
</Workbook>