I am trying to get the text(Reference data) from one cell in a sheet and view it in the footer.
Is it possible to do this?