Code for matching the data value from two spreadsheets, if a match then append data!

Code required for matching the data value from two different spreadsheets and if a match occurs appending the columns from spreadsheet master to slave spreadsheet

Hello all,

I am new member and decided to register after seeing people support one another in such a community, therefore I had to join. I listed my description in detail at the start of the message since titole box has a limited character width that can be used.

Just an overview of what I am trying to accomplish before I outline my exact needs.

I am trying to build topology for an electrical network based on an exported notepad file from a clients system.

I have gone through the tedious task of separating the equipment into different sheets. The next step is to make a connection between the various equipment so that a network can be built. There is quite a bit of work ahead of me but as a start I would like the following to be achievable

The following sheets are present
Busbars
Load

If the value from sheet Load sheet in the column B with a heading “FromID: i,” matches the value from the Busbars sheet in column A with the heading “ ID: i,” then the entire line needs to be appended to the Busbars sheet

So if a match occurs the information from columns A through to G on Load sheet should be placed in columns I through to O on the Busbars sheet

I have attached a sample of the info.

Help would be highly appreciated. I forsee the data growing with each appendage. It's pretty overwhelming reading the the documentation and carrying it through with new steps so I am going to be asking for continuous support.

Thanks in advance