Question: how to do multiple copy and paste in excel?
Answer: Open the file that you want to copy items from.
Select the first item that you want to copy, and press CTRL+C.
Continue copying items from the same or other files until you have collected all of the items that you want. ... 
Click where you want the items to be pasted.