Hello all

I have a workbook with multiple sheets. Each sheet is identically laid out
(the only difference is the sheet name - cart1, cart2, etc). Each sheet
represent the contents of a cart and the expiration date of applicable items.
I would like to create a macro or function that will search each sheet in
sequence and return on a summary sheet the following information: the name of
the sheet and any of the items with expiration dates that are within 45 day
of the current date.

Any help or suggestions would be much appreciated - see below for an example
of the workbook

Cart1Sheet Cart2Sheet
Column1/Column2 Column1/Column2
ItemX/04/01/2010 ItemX/08/01/2010
ItemZ/06/01/2010 ItemZ/03/01/2010
ItemA/08/01/2010 ItemA/03/31/2010

Summary Sheet
Cart1 ItemX 04/10/2010
Cart2 ItemZ 03/01/2010
Cart2 ItemA 03/31/2010

Excel 2007 PivotTable, PivotChart
Consolidate tabs.
Filter by expiration date.
With macro.
http://www.mediafire.com/file/nanrmlyemnd/02_19_10.xlsm