How to insert a row in worksheet A and have it auto populate in worksheet B

I'm sorry,jessica-tls1 , but I don't use VBA or macros. So if you're insistent on that, I'll have to defer to some of the other experts here who do use VBA.

Did the custom views just not make sense to you as a solution? In retrospect, I realize I neglected to mention in my last post that you'd still need to sort the single spreadsheet on your column containing those Type designations in order to have them sorted as desired, for A1 to go in ahead of AE...but again, that's all very easy to do. And once done, the Custom View for the other users would automatically display that same order.

Especially if you are expecting the people in the field (the users of Sheet B), to be entering and, potentially, changing entries under the columns also visible in Sheet A, having two separate sheets [as opposed to two different views of the same sheet] could lead to inconsistencies between the data on the two sheets. That kind of inconsistency is something to be avoided, in general, in designing a spreadsheet or workbook. So again it depends on how you and the other users are going to be maintaining your two sheets.

I'm going to defer to others for a VBA or macro-based solution, but I want to encourage you to be open to a solution that avoids the potential of data inconsistencies.