I made research around the site for a similar post, but i can't seem to construct my own from them (I've almost no knowledge with excel macros). Please help

Say you have a workbook (named inventory1.xls) of 1 sheet of 5 columns (A - E). How can you transfer automatically all data from that workbooks single sheet to another workbook (named consolidated.xls), also in a single sheet. With the workbook (consolidated.xls) automatically updated when data is added in the source workbook (inventory1.xls).

Thank you very much.
This will be used to help a non-profit NGO to improve their inventory tracking.


Thank you very much again.