I have the following formula:

=INDIRECT(CONCATENATE("'Business Won'!$Q7$",COUNTA('Business Won'!Q:Q)+5))
It doesn't work on a sheet with a space in its name.

When I was testing it on a sheet called Sheet1, it worked fine.

Any ideas how to get around this? There's going to be quite a few formulas like this.