test.1.xlsxHi and thanks for any help in advance.

I am trying to drag a cell to populate other cells with a reference to other worksheets. To make is easier i have attached a shortened version of the Excel file. In it I am trying to use cell B41 as my start point and then drag it sideways to populate the cells next to it.
However, it cell next to it will be referencing a different worksheet but the same cell within it.

EG B41 = '=Australia!N9'
C41 = '=Maylasia!N9'
D41= ETC