Matt, welcome to ExcelFox

This can be done. But the entire requirement looks more like a project request than a request for help. Maybe offering some incentive might get you going. In the meanwhile, can you clearly mention the cell address of each of the cells you require to be captured from above row 28 (the ones below are straight forward).