How to Automatically consolidate table, frm diff. tables located in diff. sheet, using VBA

Hi Excel Expert,

I am trying for a Macro, which pulls all the details into one table automatically, form different tables, locatd in different currency sheets of a same worksheet.

Tried recording a Macro, later got to know it has limitation. Its one time, when cell reference change while pasting new transaction, the recorded macro fails to update in prescribed format.

Kindly help me with a specific macro codes, which can update this master table - in Real Time TAB, in a particular format.

Basically, the items are open items which we are yet to be enter. When we enter we update the individual table currency only. However, wanted old dates/items first of particular currency.

Please find the attached sample excel file. Awaiting precious reply.

Regards
RAM