I have a spreadsheet that I the first tab is just information from other tabs on the document. Is there a formula that will make cells on one tab fill automaticly with the information from another cell on another tab. The problem I am having is that the names on the other tabs change every time we update the information.
I attached the spreadsheet so you can see what I am trying to do. The first tab is the date and the (blank tabs) all get job numbers. My clerks are having to type the information in twice, once on the job numbered tab and then put the same information on the first tab. I have been searching for a formula but I cant find anything that will change as the tabs are named something diferent each time.
I hope I explained this so someone can understand what I am trying to do if not please let me know.
Thank you
Ronnie