Lookup to return multiple values horizontally

Hi,

First time on the site today and found some very useful info.

However, I'm unable to find a way to return multiple values horizontally from different sheets on the same workbook.
I've seen various examples of this where the all the values are on the same worksheet, but have been unable to modify to fit my requirements.
I'm basically trying to return multiple values (Locations) on a per value (Circuit) basis:

I've attached a workbook (Book 1) which has the following:

Sheet 1
Shows Circuits (in some cases multiple instances) and their respective Locations

Sheet 2
Shows unique Circuit Reference values.

I would like to return the associated Location Reference horizontally against each Circuit Reference on Sheet 2 (have shown the required end result on the workbook).

Would appreciate any assistance here.

Thanks in advance

Rob