I have a worksheet with a drop box list, containing names of sheets (B2). I
want the cells in B3:F4 to carry a duplicate of the same cells from that
sheet name. Can anybody help me with a formula or macro for that purpose?

TIA
Esra