Open workbook, insert copied rows VBA code

When I open the book, I am already selecting the "Contractors" sheet with

Sheets ("Contractors").Select

and then selecting row 4 of that sheet with

Rows("4:4").Select

The

Selection.Copy

is copying what I have selected from the original workbook. Since the numbers of rows I need to transfer will differ every day, I need to select them with my mouse before enacting the macro...so I'm telling excel to copy my selection with that

I'm not entirely convinced this is the issue, I won't be able to try your suggestion until tomorrow though