I have an excel document with multiple worksheets. I want to create a summary worksheet that reflects the current status of all the other worksheets. The idea is to be able to hit a <ctrl> X for example and have the formula read through all the other worksheets and build a table of detail based on certain critieria. To keep it simple, the other worksheets represent individual projects being managed by a PMO. These sheets contain employee info of which End Date for the project is found. I want the formula or function to search all columns representing end date for each project worksheet and when a date is found, return the employee name, end date, resource manager and RM date notified. All the data exist on the same rows as the end date. This returning data is generated into rows on the summary sheet. I certainly hope this is clear, if not let me know.