Macro to Copy data from one sheet and paste to another sheet based on a condition

Hi Everyone,

I am new to Macro and need a help for creating it. Below is the scenario.

The Example sheet in the attachment has 2 tabs ALM and AIS and both the tabs having attribute name,attribute definition, table & column & transformation logic for a particular source system. Apart from this it also has EDR & EDXF Schema details(Table & column name). The table name in EDXF has 2 tables(having suffix MONTH & DAY).

The Desired Output sheet is the result which I need. I want that for attribute A1,A2 etc we should get one row(having details for A1) for each Table (MONTH & DAY) corresponding to source system SRC1 in tabs ALM & AIS.

Please see the attachment "Desired Output" sheet which is the resultant sheet.

Please refer the attachments for the scenario.

Any Help or any direction would be highly appreciated.