It can be done either via formula or VBA.

Without knowing which cells from each sheet are to be queried it is hard to
say how this should be done.

Can you be more specific?

An example.........

You want to get a total from G23 on each sheet.

In a cell on Report sheet enter =SUM(ISheet1:Sheet31!G23)


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 11:16:48 -0600, tlachena
wrote:


I have a workbook that conatins 31 sheets, 1 for each day of the month
and a report sheet. Each day has information i need to query but i have
been unsuccesful at creating a query to pull all the data into a
seperate sheet.
I'm not to savy on computer lingo so hopefully this makes sense.