ListBox in Excel on basis of cell

Hi All,

I am trying to create a ListBox which display the data on the basis of cell

For example: I have a Workbook and Cell D6 is a drop down this help me to select the different worksheet.
I am trying to create a ListBox in the excel sheet which can help me display the 2 row of the worksheet selected in cell (D6), the listBox ROW will be PRC and IREF/ARN and on basis of selecting any of the cell in the listbox is should also display data in the Cell C9:D17 and F10:G16, also I9: J12...