Create location-specific purchase records automatically from master sheet

Your central sheet of completed purchases leaves local managers without timely records, causing follow-up delays and inconsistent campaign reporting. It routes each completed purchase to the correct location workbook and logs a master entry so campaign managers get updates same day.