I would like to create a list in sheet 2 from data in sheet 1 but when I
click create list and go to select the range it will not let me click on the
tab for sheet 1 to select the required data.

Could somebody point me in the right direction please?