compare tables from different worksheets and add data

[flip01]

Hi ,

i have following problem :
i have 24 csv files (hourly reports).
Within each of these csv files, there is inter site communication displayed

example (i will attach files as well)
File A - hour 1
site - site - messagecount

site A - site B - 12
site B - site C - 24
site B - site A - 14

Fîle B - hour 2
site - site - messagecount
site-A - siteB - 20
site B - site C - 10

what i want now is 1 major excel file for each intercommunication, like this
site-site messagecount hour1 messagecount hour2
siteA-siteB 12 20
siteB-siteC 24 10
siteB-siteA 14 /

Probably an easy one for you guys , difficult one for me ...
thanks ,
Filip