I would like to create a spreadsheet that contains name, phone number, address, email address of many individuals and I will define the data as a range name "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.
Thanks,
Don
