Search and Report multiple values using userforms

Hello all,

I have a workbook for tracking patient's medical exams which consists of 3 sheets of data. I would like to use a userform to search all these sheets for a patient's name and then generate a report of the status of all their open physicals in another userform (or msgbox if that would work). I have done alot of looking around the web to try and find something like this and haven't found anything, so I'm unsure where to even begin.

In the attached example you can see how my book is laid out. The sheet names themselves represent the "status". In the code I have the userform for searching, and the userform for reporting. I want to be able to put a name in the textbox on the search userform and click the report button. I would then like for the code to search for all occurences of that patient across the workbook and populate the report userform with the values of cells in the found row (as the Report userform is laid out). The "status" column of the textboxes should populate the name of the sheet in which that string of information was found.

So, my 2 main questions are: is this even possible? and what functions would perform it?

Thanks.