malcolmlo,

Welcome to the forum!
If this is for a named range, you can use this formula. Adjust the row numbers to suit. I chose 65000 because I don't know what would realistically be your last line of data. The fewer rows it has to check, the more efficient the formula will be:
='Settings-Objectives'!$C$2:INDEX('Settings-Objectives'!$C$2:$C$65000,MATCH(TRUE,'Settings-Objectives'!$C$2:$C$65000="",0)-1)
If this is not for a named range, you can use the same formula but you will have to array-enter the formula with Ctrl+Shift+Enter and not just Enter.