I have a single workbook with several identically formatted worksheets containing varying information. Each worksheet is used to price out a finite set of materials from a handful of suppliers. The worksheets include a best price column showing the winning bid for each item. Each sheet is labeled by the date that the bids were requested. I want to collect the winning bid information from across all worksheets for each product to display the high, low and current prices in a dashboard-like format. I can't seem to figure out the formula that goes and gets the information from each sheet. Is this something I'll need macros for? Is it as easy as learning how to actually use pivot tables? I'm stumped. Any help would be greatly appreciated. I've attached a copy of the workbook here.
Thanks,
Marc
Bookmarks