Thanks for all of your help, you've been great.

So, I got data that is being entered daily in 5 columns. What I have is different sheets for each day of the month where I manually copy processed data from sheet1 to other sheets depending on the day of the month...

sheet1-processed data
may-1, may2, etc for the sheets for each month to save processed data to.

What I would like to do, is to add drop down selection in sheet1 above processed data, to be able to select day of the month sheet, and submit or load "ProcessedDataTable" from sheet1 into specified column selection of selected sheet.

Any guidance?