Hello. have multiple sheets in one workbook that are all identical in format. I want to create a formula that will return either a specific cell in each sheet or the sheet name where a specific word is found. For example, if I want to search for "Company A", I want the formula to return a list of all sheets that contain "Company A", or a list of cell A2 in every sheet that contains "Company A".