Currently I am working on a document in google sheets with several tabs.

"SS", "Math", "Sci", ...

and I have a formula I am working on in a separate tab....

=iferror(if(A2="","",index(SS!B:B,match(A2&$B$1,SS!E:E&SS!G:G,0))))
^
I am wondering if the "SS!B:B" piece can be modified to include column D from ALL the tabs, not just SS.

I hope that makes sense.