Auto populate multiple rows upon data being populated in another sheet

Could anyone help with this problem in excel-

In the spreadsheet I have attached, I want to auto populate all the columns in the Asset Attributes tab when the 'Asset Alias' and 'Asset Classification' columns are filled in the Asset tab.

There's one to many relationship between 'asset classification' and 'attributes'(shown in Asset Classification Relationship tab). So the 'asset alias' and 'asset classification' will be repeated for that many rows of attributes.

The attached spreadsheet has examples and what I want the final goal to look like.

Thank you so much in advance for any help provided.

-Lataexcel forum question.xlsm

Please apologize for posting twice. The first time around I got a message that connection timed out. So I posted again.
Thanks.