Is it possible to use sourcing to filter a custom field of locations based on a custom field of subsidiary - filtering the list of locations based on which of those locations belong to that selected subsidiary?

Yes - see the setup here:

Thanks, will try it out.