Select, Copy, Paste one by one till last data to new format

[vasandgl]

Hi Excel Experts,
Myself Srini, new to this forum. I need your help to provide a macro code for the below
Input & Output file image links are as below

Input File Image-->https://ibb.co/xLQ6dLD
Output File Image--> https://ibb.co/f0VMv9c

In Input, Rows & Columns can be n numbers.
Need to filter datewise excluding blanks from input and copy Row Lables values, Date & Qty and paste in the Output Format from Cell A3
For the dates it need to convert from traditional date format to as below.
10-Oct-2019 --> 101019
05-Oct-2019--> '051019
For a single part number, multiple dates & Qty available means it need to enter in the Date 2 & Qty 2 for the 2nd Data, if 3rd & 4th Date & Qty available for same part means need to enter in Comments 1 & Comments 2 in simple way like 20OCT-10 (ie.,DDMMM-Qty).
If more than 4 Date & Qty available means put in some error file & store.
From Input Date as TBA & Qty as 0 -->put in some error file & store.

It will be really helpful if anyone can help me.

Thanks,
Srini.