Need Google Sheets formula help

I need to do a vlookup type function that searches in a column in another tab (same spreadsheet), for any cell that contain partial text. (example: cells would contain B526-31, B526-46, B526-91 etc) I want to bring the entire range of cells that include "B526" not just the first one, which is all i've managed to do. So in the B526 tab, cell A5 - need a formula that looks in the tab "Data Import" column A and finds all cells containing the value in Cell A1 of the B526 tab. LINK is here https://docs.google.com/spreadsheets/d/1YCDf-TtTUNbNIj0ZXPGhUHO2NwFJHaSoZ8y96_YQ9l0/edit?usp=sharing