Bring a list of cells where column in 2nd Sheet matches a cell value in first sheet

Hello,

In a quandary here. I have a DistanceCalutatorByZip sheet that has a Site ID column. I have another sheet that houses all those site ID's. I would like to populate the Site ID column from the TI (sheet that houses all the Site IDs for all markets) based on Market (listed in Cell E2). Markets can have up to 2000 sites. The end result would be when the user selects the market in Cell E3, the entire list of sites in market CHI populate in Col C.


User changed entry: E2 on DistanceCalutatorByZip tab
Site list source: TI Tab
Market in Col A
Site ID in Col B
Destination: starts at Q8 on DistanceCalculatorbyZip tab