Copy Data from multiple sheets to Main datasheet

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

Hello, xladept.

Thank you. The copy code worked perfectly.

The change code you are working on, will it also update the table
of context when new data is entered into the info sheets? I have
many more materials to add.

Again, Thank you for your help.

Hi, xladept.

No, the number will never change. The number is the controlling body for that specific material type. Once the Row is added to the Info datasheet, it will never be deleted.

I notice the columns are now numbered. Could they be changed back to letters?
If not, no big deal. I can update my supporting SOPs accordingly.

I will need to add to the materials list on the info datasheets. However, I just added a few more on the metals sheet, but the new items did not show up on the table of context sheet. I tried re-running the copy code; this just adds the entire metals sheet data to the bottom of what was already on the Table of Context sheet.

Also, I will most likely need, in the future, to add new Sheets for Isotropic-Hyperelastic, Isotropic-Elastoplastic, Orthotropic, and Transversely-Isotropic materials.

To sum up:
Can I add line items (Rows) to the existing info datasheets that will copy over to the TOC?
Can the conditional formatting be copied with the data to the TOC?
Can I add info datasheets to the workbook and would they be included with the copy code?


Ps. do you have any recommendations on books that will help me understand VBA code and how to develop VBA codes?
a.k.a VBA Code for dummies


Thank you, again for all your help.
Dave