Forum Discussion
Making contact list form multiple sheets
With your permission, I recommend to provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step.
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Here is a solution suggestion with the possible integration of hyperlinks that might help you.
Create or change a cell reference
Hope I was able to help you with this information/links.
I know I don't know anything (Socrates)