I have been given the task of finding all the instances of one person and all information to go with them in each of 31 sheets in a work book and having it populate onto a 32nd page. For example each sheet is a day of the month and I need to find each time John Smith shows up through all sheets and the information on the table connected to him (I.E. sales, profit, # of customers, etc) and my boss wants it all to pull onto a new sheet.
