I am looking for a formula that will find information from a row with two unique matches that could be on one of 1 of about 50 different pages.

The equation i am looking for applies to Cells B8:B53 on the "Brain Sheet". The equation matches data from A8:A53 from the "Brain Sheet" with data in Cells A1:A500 and could be on Sheets 1,2,3,4,5.... etc. The equation also must match data in cell $B$4 from the "Brain Sheet" with data in Cells H1:H500 from the same sheet it found the proir match. Then it pulls the information in cells J1:J500 from the sheet with matching criteria and posts the information the original cell on the "Brain Sheet". All the matched critera and information needed are in the same row. What is the equation I am looking for??