I ave multiple worksheet named one, two, three, four etc. In the worksheet
with the vlookup I need to be able to get the value in A1 say 'one' to
populate the table_array. It needs to say 'one'!$1:65536, All I can get it
to do is A1!$1:!65536.