I found something that would allow me to use the name of tab in a cell to make some of my work easier =MID(CELL(“filename”,C1),FIND(“]”,CELL(“filename”,C1))+1,255) Surprisingly, I found it on the Mircosoft answers site! https://answers.microsoft.com/en-us/msoffice/forum/all/making-cell-equal-tab-name/06486c8c-a1d9-4f2b-ba17-cf147161353c