we have an excel sheet with multiple workbooks in it i.e.tabs.Now we want to
create a new excel sheet which has only 1 workbook from the actual excel
sheet.but the new tab or workbook should be updated whenever data is updated
in actual excel sheet.

I tried excel services but due to lots of unsupported items in the workbook
i am unable to use the function.

Could someone pls help me with this.