Search for a sheet based on a cell copy to that sheet first empyt cell

I have tried Google and cant find a solution
Please assist:
What I need is this
I need a Macro select D7 to AD27 on the sheet"DCWC". For this I have the following"
Sheets("DCWC").Select
Range("D7:AD27").Select
Selection.Copy ......then And this is what I am battling with
In the Sheet"DCWC" look at cell AF4 (Date format, "dd") I have a value based on the date in V4
find the corresponding Sheet, e.g. 27 in this case,
In sheet "27" find the first clear cell in Column A and paste special the date selected (D7 to AD27)

Any feedback or help will be greatly appreciated

[Sheets("DCWC").Select
Range("D7:AD27").Select
Selection.Copy
Range("D7").Select
Sheets(Range("AF4").Value).Select
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Wow Bernie, your code is much better than what I came up with.
Mine works but yours is way better
Thank You