I dont know how this is possible.
Please see the attached sheet.
Sheet1 is the main sheet with all the data
Sheet2 Cell E5 has a selection with data validation.
Depending on the data selection we make I would like the data to be displayed as below.
I have given all the data below each other for easy understanding, but in actual I want the data to be present only in ROW 8
I would appreciate a formula and not the VBA code