Search Engine across all sheets

Hello, I should start with the fact that my understanding and use of Excel functions are minimal at best. The last Language I could actually write was Pascal in the 1980's, lol.

Here is what I'm looking to do. I have a workbook that I am starting to compile data on, I haven't completed it yet, just put in some random info to see if I could create what I wanted. I would like to be able to search all the lines on five different sheets on a sixth sheet using a "Search Engine" on the sixth sheet. The data would be starting on line 2 with columns ranging from A to J, going down to say 150 lines once all the data is entered onto the sheets. I would like the "search Engine" to return the results below the search box in the same format as it is shown on the original sheet. Further if it would be possible to color code the results with different colors for each sheet that would be fantastic. I would like to use red for the warrior sheet, blue for the magus sheet, green for the sentinel sheet, gold for the gunner sheet and purple for the assassin sheet. I have attached a copy of the excel workbook I have started. I have only populated the warrior and magus sheets with some random data for a couple of lines.

Is this even possible? Any help would be greatly appreciated. Thank you!

Thank you for the quick reply. I would like to search for any matching words or parts of words. For example if I were to search for the effect 'bleed' I would like the search engine to return the results showing the match under the warrior sheet for the entire 3rd line and the entire 5th line from the magus sheet. this way I would be able to see all the effects from the "Fictitious A Talisman" on the warrior sheet and where its located, how many are in a set, etc., along with the same information for the "Magus C Talisman" on the magus sheet. If it would be able to highlight the warrior red, and the magus blue, even better. Thanks Again!

Marvin P, surprisingly I was able to find this and make it work for me, but its a bit clunky. The problem is that as illiterate as I am in Excel, believe it or not some of the people I'm trying to compile this workbook for are even worse!! I'm trying to make it as user friendly as possible for them. As the old Army saying goes Keep It Simple Stupid or K.I.S.S., lol

ok, that is way beyond me!!! lol Guess that's why I'm asking for help after all. But what do I do with that? Do I copy and paste it somewhere? Thanks for everything, and putting up with my stupid questions

Thanks! I think I can follow that well enough. I'll try it tonight when I have access to the computer, wifey is using it during the day while working from home. Thanks again!

Alan, thanks for the update on how to enter the code, I was able to do that without an issue. However I did receive an error, not sure what they mean, so I have included a screen shot of the error and a screenshot of what happens when I hit the 'debug' button. This is Greek to me, lol. Thanks!Attachment 671459Attachment 671458

Sorry, Here are the screen shots, Thanks

Ok, I will make sure that the Tabs have no spaces before or after the name when my wife is done later. If everything works ok I will make sure I come back here and mark this thread "Solved". Thank you for everything

ok, I found that I did indeed have a space after one of the words for the tab. Once I corrected that the operation did run and little box popped up saying 'completed'. What it seemed to do was to populate everything onto the first tab (introduction). What I was looking for was a way to create a search box (perhaps in cell B1) on the search tab, and have the results populate below the search box. Am I doing something wrong? I have included a screen shot of what did happen when I ran the code. Thanks again for your help!