SharePoint Cross-Site Lookup
Cross-Site Lookup allows you to look up and pull information from any site in a site collection, adds find-as-you-type functionality to your lookup field, and filters items displayed in the lookup field according to a view defined in the source list (the list where the information is being looked up from).Maintain the integrity of your data by creating relationships between a list and another column in another site with Cross-Site Lookup.