Lookup and return table values based on tab name

I have an interesting problem that I have been working on and am stuck at this point. I have a Master sheet with table values for various "methods". I also have 3 sheets named after these "methods" like "H", "E", and "O". In those sheets there are basic patient and QC info, such as the name and ID#. What I need help with is depending on what the tab name is, like "H", additional information that is contained in the master table needs to be pulled for the respective patients and QC that are present. To give a better picture of this, I have attached a file that has a few example methods (the red tabs) in their original form, and what they should look like after (green tabs) they gather information from the master (Black Tab). Help would be greatly appreciated.
Master lookup question.xlsx

hi RaydenUK, option, please check attachment, press Run button on Master sheet or run code "test" (ALT+F8, select "test", press "Run" button)

Wow thank you watersev! Is there any way to make it just work on one sheet and not all the sheets. So if im on "H" then only run it for "H" and not the others. I should have been more specific, my apologies. But thank you so much for this.

option, please check attachment, run code "test" while on any sheet except Master

That works but now only the patient values show up. Everything is still blank on everything else.

you asked to process only currently active sheet data, it provides result for active sheet only

do I miss anything?

I discovered why... I actually have more information attached to the qc values than what the table has. For example "Q01QC1" may look like "Q01QC1_A_3_031515_2". So can the code flex to just recognize if the name is contained in the cells? Im sorry I realize I should have put that on the spreadsheet. This will be the last thing, I promise.

may I have a file sample? What is the delimiter to identify end of the code in the string like "Q01QC1_A_3_031515_2"?

This is what I should have sent to begin with. Sorry and thank you again for all your hard work.
Master Lookup Question.xlsx

please check attachment

Genius. You did it once again!! Perfect! Thank you! Thank you! Thank you! I owe you tremendously.

Here is the file I had messaged you about watersev

Master Lookup Question.xlsx

please check attachment

Watersev, how would i change this code if I wanted to have the "master" sheet on a different workbook with the path C:\Desktop\Master sheet only.xlsx?

please check attachment