Yes - it requires a sofisticated process called “you be the macro and play the game”.
Macros can’t do a few things any more - target enemy players. A macro can be asked to choose a target but it can’t distinguish whether it’s a player or not. It may also select the immediate target or one out of range.
You also can’t get it to do 5 things then reset the target. WoW wants you the player making those choices not a mod or macro.
To achieve what you are wanting you are going to have to micro manage your macro and makes these choices for it.