VBA Script to help moving data from one spreadshee to another in appropriate column and ro

I do not know VBS script at all and have had code written here for me before. I apologize in advance that i am asking to get something done with nothing to show.
I have a 2 files one is file is a month and i will alway have the correct month opened when doing my work and i have the second file that has peoples names that wont change in column A and a location is column B and a count is in Column C.
I need the name on Counts sheet column A to match Row 1 on 01 - January.xls and then check for the center number on Column B on Counts to match Center Number on O1 - January to copy the data from Count.xlsx Count column C to the correct location on Janauray. Sorry for the confusing information but the spreadsheet i have attached has the information pasted where it belongs.

I am getting an error at
Set srcWS = ThisWorkbook.Sheets("Data")

As if it cant find it. Also i did not make this comment did not know how in depth i needed to go. This will be done daily for every day of the month for every month. Not sure if i have to change the file names in this or not each time but that is something simple that can be done (Set desWS = Workbooks("01 - January.xlsx").Sheets("14")). I will always have the correct day open and the correct data to go into that day.

The sheet name is Data

The macro is in Personal macro sheet

I have to download this sheet everyday and then run the macro for each day in every month.

That worked perfect. So now i just have to change the name to the correct month and correct day each time correct?
Thanks

I did not give enough info when i started this. I do this for months 01 - January.xlsx to 12 - December.xlsx all months. Each month has 31 days in it and i have to download the count sheet each day and put the information in manualy. With your macro i dont have to do that but will just have to change the information in the macro for the month and the day. Sorry i did not give enough detail to begin with and thank you for you help.

I have a question for you. The above works but i cant run this everyday so it will not work all the time. Is it possible with the original code you provided me if i added a day field in E1 with the day of the month (example 21) would the vbs be able to determine from E1 to put the data in day 21 of the Month that i have open such as 03 - March. Sorry to pester you on this. I already have made what you have given me work but trying to explain to someone else to change the vbs is another thing when i am not around and can do this.
If this is too much leave it be and i will be fine with what you have already provided it works and i can deal with it
Thanks again

Not sure why it is erroring on this but here it is

desWS.Range("C2:L" & lRow).ClearContents

error stats method Range of object worksheet failed

I understand i have extra data that is not needed in D and E. I removed that data and it worked you are awesome. One day i will get into doing VBS because it is really useful.

It did and adding the date to type in was a great idea so thank you. This forum is great for any help.

So i have been using this for a week now and it has been fine and i have not changed anything but now it is giving me an error at

lRow = desWS.Range("A" & Rows.Count).End(xlUp).Row - 1

error that comes up is Object variable or With block variable not set. Any idea what could cause this.

after doing a little testing the macro works in 02 - February but does not in 01 - January.xlsx. Not sure why but i just ended up taking what i needed for Jan and putting it in Feb then copying that data over to Jan. Made it work but not sure why it does not work in 01 - January.xlsx.

It is not another macro it is just editing the way the excel looks just deleting field and clearing content. Then it run the script you created for me. The macros are in the personal book. all seems to be working now though so no changes are needed. Think it was a excel issue.