Help with formula to pull multiple criterian from one sheet to an organized list

I hope this title is non-infraction worthy...
In the attached example I used the following formula to pull the required data from 'Sheet2' to the corresponding column on the sheet labeled 'SKU Lookup':

{=IF(ROWS($A$2:$A2)>COUNTIF(Sheet2!$A$1:$A$375,$A$2),"",INDEX(Sheet2!D$2:D$375,SMALL(IF(Sheet2!$A$2:$A$375=$A$2,ROW(Sheet2!$A$2:$A$375)-ROW(Sheet2!$A$2)+1),ROWS($A$1:$A1))))}

Is there a similar formula that will pull the data from 'Sheet2' if I enter the necessary search info (as seen on the tab labeled 'Everything')? I know I'm doing a bad job of explaining what I need and I apologize since I'm pretty new to Excel. I think if you take a look at the attached examply you will understand what I'm getting at...

Any and all help is greatly appreciated!

Everything Lookup.xlsx