Use copy+paste that will recognize values in sheet

I’ll try my best to explain, but my company uses an equipment tracking list on excel that is divided up by days of the month, with a drop down list for the equipment. When a piece of equipment is selected, it is no longer available on that list for that day. Some of these lists are huge, snd it can take hours to build a weeks worth, so it would be great to just be able to copy and paste day to day; however, when we do that, it doesn’t always subtract the equipment from the list, thereby making it look like we have equipment available when we really don’t. Is there a way to copy and paste that will acknowledge the drop down list?