Merge multiple files into single based on criteria

Hi all,   EXCEL DATA ATTACHED    I have miltiple INPUT TAB in this format:     A product CHANGE TAB, shows when a NEW LINE will be created in OUTPUT, based DATE RANGE on change in LOCATI...