I need to have a column auto-updating from every-other column of a row on a
different worksheet - literal example:

'ValleyResultsVsBadDay' column A is identical to Column (B,D,F,H,J,L, etc. -
all the even-indexed ones) Row 5 of 'ValleyLots'.

Is there a way to use Indirect and Address to refer to a different worksheet
like that, or is there a simpler, quicker way to make a function for that
task?