Need macro help with copying data to a summary sheet

Hi there,

Please see attached document.

I am currently building a biweekly document that assigns work based on task selected along with other variables. I am running into trouble figuring out how to give users the option to click a macro button at the end of the data to transfer the relevant data to a summary sheet at the front of the document. The summary sheet records the user, the date, the task assigned, and how much was assigned so it can be matched at a later date when completed.

I have a hack job macro built to copy data using a global variable and the concatenate function to bring over the data, which was kind of working, but now is causing problems as I had to add functionality to the spreadsheet. I had to use three separate macros in the document, one for the "Monday" spreadsheet as it has no "sick" column, one for every other sheet that did have the extra, and one for the "FridaySpecial" as it mostly manual entry that effects the "Friday" sheets.

The problem is that the Macro is breaking randomly, or breaking if Monday isn't used (global variable) and how I had to add in the OT work functionality makes it so it summarizes weirdly on the summary page. The summary thing isn't the end of the world, but I can't figure out how to get it work differently.

I am sorry, I am still new to the VBA world, but I gave it my best shot. Is there a whole method of doing this that I am missing? Any help would be much appreciated! If I didn't explain things well, please let me know!

Thanks,

-Catalyst

This is great! Thank you!