Formula for Tab Content

[Karen]

Is there a formula I can use for a cell that will populate a cell with the
content of a sheet tab?
Thank you, Karen

 

[Mike H]

Karen,

Put this in a cell. The workbook must be saved for it to work

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Mike