I was expecting to make a macro, but I've made an app instead!
I'm not quite sure I understand the bonus question. I did some transposing and dynamic renaming so you get a line of data per date with multiple previous dates (if you type multiple dates into the app). But I wondered if this was a batch macro thing... Looking forward to seeing what others have done!