Create scatterplot graphs with identical formatting from over 50 different sets of data

Hi,

I need to create a scatterplot graph from columns BCE, LMN & VWX (I have over 50 tabs with those same columns showing different data). I would like the graph to be formatted like the one under (FGHI) in calibri size 8. There are 3 graphs per page. One for 6 months regression, one for 3 months regression and one for 1 month regression so the data for the graphs is being pulled from 183, 91 & 30 rows respectively. I would also like the graph to show the data in cell F8 (which has only been concatenated because I couldn't figure out how to import cells G2, G4 & H3 into the title) I would also like to show the value point for today's date (shown in red) and 1 week ago's date (shown in blue). Everyday I update the work sheets so it pulls in another day of data from bloomberg.

Any Macros or VBA for this would be HUGELY helpful so I don't have to create them all manually.

THANK YOU IN ADVANCE!!!
Andrea