I want my coversheet to find the end of the row to roll-up the month end data. I want to automate the coversheet so it adjusts for the varying days in the months. That said the answers to your questions are:
1&2. i suppose the column will be all i need to get the reference for the coversheet
3. either numeric or text depending on the row.
In response to your PM regarding my formulation ...
The REPT("z",255) is to create (for lack of better words) the largest possible text entry that any cell in row 3 could have. The MATCH function in trying to match this entry against all the entries in row 3 after failing to match it reports the last text entry in row 3 -- thus giving me a number to correspond with the column that houses the entry that resulted from the use of the MATCH function.
Then to convert the number to its letter counterpart for the column I used the ADDRESS function.