Formula that use cell string data

Hello, I have a bunch of tabs in a excel spreadsheet. These tabs are all labeled and the labels are also copied in cells.   In one of the tabs I am referring to the contents of other tabs by us...