Hi Paul,

Thank you for the response! That makes sense.

I've tried it and am still getting the below error:

error.PNGerror code - vba highlighted.jpg

I have my target workbook open as well as my two other WB's with a sheet called "BOM-Detailed Components" in each one that I'm trying to copy over into my current WB