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

crazyshoots,  @Wyn Hopkins Did the two of you look at the original workbook sample that @jessica-tls1 posted. She has a lot of empty cells in hidden columns in her Sheet B. This led me to think that input is ultimately expected on Sheet B as well as on Sheet A.

The "presenting problem" is one of inserting a row so as to have the various items listed in a particular order. What's never been made clear is exactly how Sheet B, which would appear to be a secondary sheet, is going to be used. It definitely appears to be more than a simple 'output." If it were that, only an "output" document, the Pivot Table would work (although, again, the multiple hidden columns that are there and NOT on Sheet A, raise questions).

My own sense--pending a fuller description of the full "business process" here-- remains that she'd be better off with Custom Views of a single spreadsheet, one that includes all columns that will eventually be needed, going through these steps:

1. enter items in any order into the equivalent of Sheet A, a view that only displays those columns
2. use Data....Sort...when needed to re-arrange the order to that desired
3. use Custom View (any number of which could be created, as needed) to display whatever arrangement of columns is needed at the time

This would allow what currently is Sheet B--but would simply be a different View of the same underlying data table--to be used for simple information OR for data input.

(And, frankly, I think it would be simpler once established, than a Pivot Table with all sorts of filters.)

Fundamentally, though, we need a more complete description of how the input and output will be used, and as crazyshoots has said, how frequently (and by whom) data will be updated. Without that, any "solution" may be off-track, making things more complicated than they need be.