Need an excel macro that which can select data from drop down list and copy the contents of the entire sheet into a new work book

I have a dashboard which contains many formulas that change depending on the value on the drop down list. Is there any macro which can run a loop for all the values in the drop down list, copy the contents of the entire sheet and paste it into a new workbook?