Summarize data from columns in multiple sheets to a single datasheet of rows

RCM, worked beautifully! The only change I had to make was the text month/year to a date format. Thank you so much for both replies! I didn't need to try the other one. Thank you so much!