Hi. It seems simple enough to be done In a few hours. I would appreciate a screenshot of how you organizing the data on your sheet. By it I mean there are three levels: dates, sources and ranks(=values)
After I receive that last piece, I'll be able to start working on it and provide you with a working solution in two days or even less.
Have a nice day!