Not sure what that OFFSET is doing there...
I believe that can be purged.

How do I adjust the scope to include the whole workbook?