copy paste from one workbook to another and find specific worksheet

[RedOctoberKnight]

Good Morning.

I have a simple copy paste code from workbook to another but my question is, how do I get it to find a specific sheet based on value in C1 and paste there?

Workbooks("Truck Schedule Builder.xlsm").Worksheets("SUN").Range("A2:D9").Copy _
    Workbooks("Truckschedulesduelsides.xlsm").Worksheets("Sun 4-3").Range("A2")

I want it to copy the Truck Schedule Builder worksheet and paste it into the truckschedulesduelsides workbook but find the specific sheet that has the same name as the value in C1 on original copy sheet (truck schedule builder)

Any help would be much appreciated.

Thanks,

 

[RedOctoberKnight]

As this is a total different question, it needs a new thread. Thanks

my apologies.