I figured out that I had "Sub" too many times. Now I'm getting a Complie Error: Expected End Sub, and it highlights the Private Sub Command2_Click()...here's the code I'm using...
Private Sub Command2_Click()
Sub Copy_Files()
FileCopy "S:\2008 MSDS (Updated)\0010 - Ammonia, Anhydrous.pdf", "S:\Jessica's Database\Linked Files\Job Plan-YARD\0010 - Ammonia, Anhydrous.pdf"
Next FileCopy
FileCopy "S:\2008 MSDS (Updated)\0080 - Chlorine.pdf", "S:\Jessica's Database\Linked Files\Job Plan-YARD\0080 - Chlorine.pdf"
Next FileCopy
FileCopy "S:\2008 MSDS (Updated)\0452 - 2, 4-D Amine 4.pdf", "S:\Jessica's Database\Linked Files\Job Plan-YARD\0452 - 2, 4-D Amine 4.pdf"
Next FileCopy
FileCopy "S:\2008 MSDS (Updated)\0458 - Diuron 4L.pdf", "S:\Jessica's Database\Linked Files\Job Plan-YARD\0458 - Diuron 4L.pdf"
Next FileCopy
FileCopy "S:\Terminal Operations\Sterlinton JSAsNew Folder\EQUIP - GENERAL MAINTENANCE\JSA 107 SPRAY WEEDS.xls", "S:\Jessica's Database\Linked Files\Job Plan-YARD\JSA 107 SPRAY WEEDS.xls"
Next FileCopy
FileCopy "S:\Terminal Operations\Sterlinton JSAsNew Folder\EQUIP - GENERAL MAINTENANCE\JSA 116 MOW GRASS.xls", "S:\Jessica's Database\Linked Files\Job Plan-YARD\JSA 116 MOW GRASS.xls"
End Sub