Macro to add data from one sheet to another (by searching sheet contents)

Afternoon all,

I am attempting to create a macro to search a particular sheet in a workbook and copy certain cells into other exiting sheets in the workbook.

In the attached example document I am looking to copy Columns E and F and then search Column A to find the name of a corresponding sheet in the workbook once the relevant sheet has been found then the copied information should be pasted into the appropriate column within the named sheet.

I have completed this process manually for the tab titled 'ASSET1!' as an example of the desired end result.

Ideally i would like the macro to cycle through all entries in the 'Join_Data' sheet and paste the relevant information into each corresponding sheet.
*The number of entries for each 'ASSET' is just an example, the data positions will vary each time the macro is used*

Additionally it could be possible to join the information by using the contents of Column B? This data acts as a sort of Primary Key...just a thought?

I would appreciate any assistance that is available.
Looking forward to hearing back from someone.

Than you in advance.

Regards
Ethanrholt

Thank you Rioran,

That seemed to work perfectly. I placed your code into my actual workbook and had to make a couple of tweaks to finalise it.
I appreciate your input! Thank you very much.

Regards
Ethanrholt