Sandyl wrote...
....
. . . so only wanted to know
if PULL can be used in this way as I don't want to continually type in
the filename of each spreadsheet (this will continually grow).
....

pull can be used the same way as any built-in function can be used, so

=IF(pull(OneThing),pull(SomethingElse),"")

should work.