Footer reference cell value

[Russk68]

Hi All
I have a worksheet with multiple pages and each page has cell with a value that I want to appear in the footer in each sheet.
For example:
A1 is for page 1 and is "Apple"
A51 is for page 2 and is "Orange"
In the footer for page 1 I need "Apple" and page 2 "Orange"
Possible with VBA?
Thank you!

 

[ExcelGzh]

If you enter this search term "excel vba footer" into your favourite search engine you should find something that suits your needs.