I have a spreadsheet with 30+ tabs.
All tabs have the same columnar setup
I need to pull out all rows across all tabs which contain a single value found in a column cell (in this case; column C)
Ideally, the report should include the tab name
Some customer order numbers exist over different tabs...