I am looking to copy an entire row from one tab to the other based on what is in column A. In addition, I would like to sort the rows copied by what is in Column A (in this order...MIDS, DAYS, SWINGS). I would also like to have a definitive break row better the results. I have attached screen shots of what I currently have as well as what I'd like. This is meant to be a long range shift and appointment tracker for my unit. the Calendar is the long rang of all appointments and vacation and the schedule is the sheet we use to post for the week. I am currently using a hlookup to pull the data from one tab to the other but have not thought of a way to have a distinctive break between the shifts (Mids, Days, Swings). I'm fairly new to VBA so any help is appreciated.
https://ibb.co/m69u9K
https://ibb.co/e3wrpK
https://ibb.co/cuw5ie
https://ibb.co/m69u9K
https://ibb.co/e3wrpK
https://ibb.co/cuw5ie