Hi, i have 7 sheets. I want to write a name in sheet "search", in G1 and the
macro formula (i guess), to display in the same sheet, a list with all name
it founds. But i want to display name and 4 other cells next to name.
Something like in this example:

a b c d e f
g

1
john
2 john b 1978 id 03 12.06.08 NO
3 john b (ed) 173 id 03 05.06.08 YES
4 john (ec) 53 id 03 31.05.08 YES

The problem is that some names have parentheisis and second name "john b
(ed)". And i want the search to ignore the parenthesis and to display all the
names it found, like in example. I want to display the name with second name
and parenthesis (if it has one), but in search i will write only john, but
the formula to ignore parenthesis when its searching.

I need to search in 5 sheets only.

Thanks in advance!!