Based on the selection in the dropdown validation lists - values within the drop down to iterate or loop through and filter the Summary, Order, Prod sheets - generate xl files and save file name(s) with "EMPID_Department_Month"


mentioned the required scenario in the file attached here. would request to for support and appreciate on quick help.


please let me know if there any point needs clarification.
Loop Thru Data validation list & filter multiple sheets - generate files with multiple sheets_V.xlsm