Yes thanks - I may have not asked the question correctly but I found out that to do what I wanted I had to include the sheet name before each name
ie 'Sheet1'!TestRange as name, Refers to ='Sheet1'!$A$1:$B$3
and 'Sheet2'!TestRange as name, Refers to = 'Sheet2'!$A1$B3
Thanks for the reply