I am trying to find a way to attach a worksheet from an external workbook to a choice selected from a combo box. Ideally this combo box is located in the Rollup workbook that has links to the external workbooks for individual depts. When the dept# is selected and want the dept's sheet displayed.