I don;t have the sample automatic one.
To be honest I have different data in the drop down list meaning months(Jan, Feb, Mar, till Dec & Q1 to Q4) so everymonth I should select respective months accordingly, then I am pasting the data in different tabs, so there are 40 tabs. This task I am doing it manually, it takes 2 hours to do that. If I write a code it save my time. Hope do this clear?