Been having some trouble with this using VBA. I can't seem to get the code to run properly.

Actually, if there is a way to get a right footer on one worksheet to be referenced in a cell on another, that would be even better but I haven't been able to find anything like that possible.

If anyone can help, it would be much appreciated!