Hey guys,

Wanting to create a macro that can loop through a drop down menu (O19), refresh worksheet, and then copy and paste range (B13:AF130) as values to specific worksheets (ex: drop down option 1 pastes to worksheet 1, option 2 pastes to worksheet 2).

Any help would be greatly appreciated!

Thank you!
-J