Import several sheets of data to workbook

[Hokkaido]

Hi,

Summary: I need to transfer multiple sheets of raw data into multiple sheets of data in another workbook.

I have a Business Intelligence document of several reports (10-30). All of these reports are on weekly basis copied to a workbook that we use for consolidating the data. I'm now trying to figure out a way to get away from all this copy/paste and build a more automatic and reliable system.

Unfortunately I cannot tap into the source data (company restrictions) so I will have to use BO as a middle man. I was thinking that maybe I could run the BO data to an Access database and from there create a link to excel but I'm sure that there is a better way that you can help me figure out

Many thanks in advance!

[Olly]

What's the format of the "business intelligence document" ?

It would, of course, be much more efficient to get the data from source. Can't you get your BI team to build the data extract you actually need, instead of bodging it from preformatted reports?