How To Copy Data By Worksheet Name

[TomyLee]

Hi,

My workbook has sheet "Main" and other sheets with names like Oct-2012, Nov-2012 ....Ian-2013... Dec-2020)

Sheet "Main" is a report, all other sheets are hidden.

In B7 you can choose "All" or Name1, Name2....Name27
In B2 you can choose January, February ....December
In D2 you can choose 2010, 2011, .....2020

If in B7 is "ALL" and in B2 (month) October and in D2 is 2012 Then:
It will copy range(B8:B34) of sheet Oct-2012 in "Main" worksheet in Range (B8:B34).
It will copy range(C8:Q34) sheet Oct-2012 in the "Main" sheet Range (D8:R34).

If B7 is "ALL" and in B2 B2 (month) Novembre and D2 is 2012 then:
clean range(B8:B34) and Range (D8:R34) in sheet "Main"
It will copy range (B8: B34) of sheet Nov-2012 in "Main" worksheet in Range (B8: B34).
It will copy range (C8: Q34) sheet Nov-2012 in "Main" worksheet in Range (D8: R34).

and so on ...

if in B7 if you not choose "All" then will be no data in range(B8:B34) and Range (D8:R34).

Thanks for any help.