Copy/paste this to quickly build these formulas:
=IFERROR(INDEX(ReferenceSheetPickContentColumn, MATCH([CurrentSheetMatchColumn]@row, ReferenceSheetPickMatchColumn, 0)), "")
Then just double-click the concatenated-word segments, replace the outer ones using the ReferenceAnotherSheet link from the Formula Help panel that automatically appears [except when looking within a sheet*], and the inner one by just typing the column name.
In the reference sheets I replace "Range 1..." with "Pick[NameOfContent/MatchColumn]" and tap the applicable column heading.
* - People usually think of using INDEX/MATCH between sheets, but there are slick occasions to use it within sheets, too.