There are a few ways of doing what you want:

http://www.rondebruin.nl/copy3.htm

Or, for a full list of Copy/Merge options:
http://www.rondebruin.nl/tips.htm


Regards,
Ryan--

--
RyGuy


"robertsdairy" wrote:

we have a different workbook with several sheets for each day of the month.
We would like to create a monthly consolidation of particular fact from each
of these workbooks please tell me how.
--
bob