This question already has an answer here:
I would like to create a spreadsheet that contains name, phone number, address and email address of many individuals. I will define the data as a range named "Index".
Then I would like to create a multitude of spreadsheets that contains some of the names and pull the phone numbers, email address etc from the spreadsheet that contains the various data.
The reason for doing this is that I would have one place to store emails, phone numbers, names so I would not have to make changes to the multitude of files if the email address changes.