Find a text string and return that cells contents plus adjacent cell contents

Hi I need to find all the customers I have sold a particular product to over the last 7 years, i have a workbook with a tab for every month which has ros listing every customer and the products they ordered. I need a formula to seach the product coloum for every tab and return both the contents of that cell as well as the customer name, order number and order date from the same row. The cells in question for the first tab (Jan 2013) are G2 - G220 which I need to search for the word Suunto, and if it contains it I need the results to show me results for G1-G220 (Product orders) as well as C2-C220 (Order number), D2-D220 (Customer Name) E2-E220 (Date Ordered)

I'm happy to drag the formula down for each tab as I can't imagine theres a way to search the whole workbook and return all the info I need?

Any help appreciated please for the right formula

Thanks
Noels

Hello,

Please attach an example file showing your problem so that we can understand correctly what you want!

Regards,
Ziky

For Data protection I've change the customer names to Customer 1 etc so I need to search G and only return details if it contains a Suunto product so in this example I need details from rows G5 and G9 and I need the contents of G as well as C,D and E. this is the tab for Jan 2013 and I have tabs for eveery month up until July 2020 which I need these details for.