Hi, I am new to the forum and this is my first posting. I have only created a few simple (very simple) VBA codes in the past.

I have a workbook that contains multiple sheets, currently five sheets of which only two of them are Info Datasheets.

I would like to create a VBA code that pulls data from multiple info datasheets and compiles that data into one Main Database sheet. However, after that initial collection, I need the code to maintain the rows data. Specifically, if any row’s data changes in the info Datasheets I need that row on the main Database sheet to update.

The columns in the info datasheets range from A:AH, however I only need the columns A:E to be copied. And I would like the code to add column F in the main datasheet displaying the sheet name were the data was retrieved

Each Info sheet (Metals, Polymers) are setup identical;
Rows 1:3 are the headers, and Column D and/or Column E will denote a change to the row.

The Main Database sheet (Table of Context) has 2 rows for the header. So, the data will start on row 3

F-S886 (Material Properties Database)_DRAFT_5.xls

Any help would be greatly appreciated,
Thank you
Dave