> Like, for example, that the cell Est Hrs always falls on column E rows 5, 15, 25, and so on. And then "scan" through the spreadsheet to extract the values.

Stated simply, if you don't what's in the columns, you can't covert them, no matter what method you use.