You can replace the "set ws = " line with set ws = activesheet, so you can activate the sheet you want, call macro, and activate next sheet, etc