I need to use an Indirect to another wookboot that has a multi-word name ie
'expense report' not something like 'er' in my excel I did the following to
test
a1 = [expense report]
b1 = sheet1
c1 = a2
d1 = indirect(a1&b1&"!"&c1)

if I use a name in a1 with no spaces ie 'er' then the indirect works but if
I use the above example I always get #ref error in cell. Anyone got any
ideas?

I also did try d1 = indirect("'"&a1&b1&"'!"&c1). It didn't work either.