Dynamic Data Validation From Other Worksheets?

Sheet A - The user input form. There is a column which needs data validation. I want it to look at Sheet B and ONLY accept values based on a column value from the other sheet

Sheet B- Contains the list we want the data validation from. One column is considered the lookup value, while the other is what we want the user to be selecting from.

Here is an example list:

Predecessor Entity Key---- Item ID
2659407------------------- SHELL - SOUTH TOWER
2659407------------------- MARKING / LABELING
2659407------------------- FOUNDATIONS & SUPPORTS
2659410------------------- UPPER HEAD - NORTH TOWER
2659410------------------- FOUNDATIONS & SUPPORTS
2659410------------------- LOWER HEAD - SOUTH TOWER

So, in Sheet 1, if one of the triggering values is 2659407, I want my data validation to ONLY Allow the first 3 values from the Item ID column.

The issue I am having is using a pretty messy formula to try and produce a dynamic range for the Data Validation to use.

Here is what works:

=INDIRECT(CONCATENATE(ADDRESS(MATCH(J4,A:A,0),2),":",ADDRESS(ROW(OFFSET(INDIRECT(ADDRESS(MATCH(J4,A:A,0),2)),COUNTIF(A:A,J4)-1,0)),2)))
where J4 is the lookup value/1st column depicted in our simple example

This is done on the SAME sheet. So I figure, just add "'Sheet Name'!" for the first argument in CONCATENATE. Unfortunately, this does not work. How to get this to work on an outside sheet?

Update:

Also tried:
=INDIRECT(CONCATENATE("'Profile Item Library'!",ADDRESS(MATCH(J4,'Profile Item Library'!A:A,0),2),":",ADDRESS(ROW(OFFSET(INDIRECT(ADDRESS(MATCH(J4,'Profile Item Library'!A:A,0),2)),COUNTIF('Profile Item Library'!A:A,J4)-1,0)),2)))

The error I get is that I cannot Reference other worksheets. However, If I type in ='Profile Item Library'!B1:B18 for the Data Validation argument, it works.