Copy/Paste Import/Export Data VBA Code

Hello,

I regularly export data from the Cognos 6 operating environment. The data
is exported into nternet expolorer into the "Excel 2002 format". Once the
data is importing into the Explorer, I copy and paste 7 sheets of data from
Explorer into Excel one sheet at a time (if it helps there is an 8th sheet
that exports each time that I don't use).

Once the sheets are pasted into Excel, I have formulas (the formulas are not
VBA, they are standard Excel formulas) that produce reports from the data.

It's be nice if I could use the move or copy the sheets into excel, but my
forumlas would not read the newly created sheet.

Is there at macro that can expidite this process from Explorer to Excel?

thanks,

Curt J