Help with getting data to go from one spreadsheet to the correct named tab

A person in another forum i dont remember which one helped write this code for me.
The code is written as such
The two files will be in the same folder and the Pastedatahere.xlsx file has to be open.

Originally i was only doing this a month a time but i am being requested to go back years.
So i have attatched the file Pastedatahere.xlsx and the destination file Location.xlsx

What i am asking if it can be done is for the data in Pastedatahere.xslx
put the data from it to Location.xlsx in the correct month, day and hour

Information on spreadsheets listed below

From Pastedatahere columns
A = Location
B = Day
C = Hour of day
D = Counts from that day
E = Month

From Location.xlsx.
Top row is day
Column A is Hours
And the tabs along the bottom of course are months

The outcome should move the data from Pastedatahere.xslx and put the data in the correct month tab
the correct day and the correct hour. i am sorry i am asking so much i am not a programmer at all
but have been tasked to get this information.
Thanks for any assistance. I know excel decent but not VBS at all. Working on learning it through what i have been shown and through the help wizard.

I don't know if I understood correctly, but try this macro:

Please Login or Register  to view this content.

This worked exactly as i requested. Thank you so much i will exam the code so i understand it better and try to learn how to use VBS in my future.
Thanks