Multiple Match Criteria

Im a little stuck on an issue im trying to resolve - obviously thats why im here right?

I have some raw data that im trying to organize on separate tabs. What Im stuck on is getting a formula that will pulled data based on the physicians and the type of visit. Can see on the tabs the data im trying to get.

Thanks in advance.