I know I've seen tips on this here before, but I can't
find them now.

I have set up some web-queries that are on 6 sheets
in a workbook. (The source data is paginated; setting
up 6 queries, one for each page, was my solution.)

Now I want to work out a macro to combine the data from
the pages into a new workbook. I'd like to copy various
of the cells based on filtering criteria and edit others.

But we could start out more simply. Would someone be able
to get me going in the right direction with some sample
VBA that just cycles through the pages and finds and copies
the ranges of data into the new sheet? Would be most appreciated.

--
dman