Run-Time Error 1004..... Can't Figure Out How to Resolve

What I'm trying to do is create a module that, when ran, will take specific cells within an open workbook (Called MCCIP Template) and then save them into a specific, unopened workbook (called CIP Directory). Workers will fill out this MMCIP Template, click a button containing the module, and the module will do the rest. They fill out this MMCIP Template a lot, I want this CIP Directory to keep track of all the important information (Date, Time, as well as other relevant info).

I've got the save part down, that's obviously easy. The issue comes when I try to copy and paste info from the open workbook into the closed workbook. The section of code for copying just this one cell looks like this:

Please Login or Register  to view this content.

The line causing the issue is the OutputFile.Sheets("Main Plant").Range("A1").End(xlDown).Offset(1,0).Select.PasteSpecial Paste:=xlPasteValues

I'm getting "Run-time error 1004: Application-defined or object-defined error"

I've done some Googling and can't seem to find what exactly the issue is.

Neither of these worked, unfortunately. Still getting the same error.

I tried this, as well. Still getting the same error on the same line.