Hopefully this is the right forum, this is my first post. I have a workbook with 8 worksheets in it. I am looking to have a 9th sheet (the summary sheet) that will pull all the data from each of the sheets based on the value of 2 columns. For example, there is column A to G, with B having a date and G having a status (either "Open" or Closed"). On my summary sheet, I want to be able to input a date a status and then show the entire rows data for everything that matches across all the sheets. The one caveat is that I want to do it with formulas if possible. I have searched the web and found some different options using arrays and ranges the MATCH, INDIRECT, INDEX and COUNTIF functions, but nothing that really covers pulling the whole rows of data across multiple sheets. Also, this needs to be dynamic to so if more rows are added to the individual sheets, the summary sheet will pick those up as well and update. Is this possible without VBA? The columns on each sheet are identical and all formatted the same. Any help would be appreciated. Thank you!
I have attached a sample of the basic setup of the workbook
Bookmarks