I am a technical business analyst with 15 years experience building high level automation, reporting, and tracking solutions with Excel, VBA (macros), and SQL.
I would love to work with you on your manifest doc, I have about seven years experience working in warehouse organisations - so I am extremely familiar with the concepts involved!
For what you are after to work automatically, you are going to need some code (which can be set to run automatically when data is added to the first tab), as formulae will lose the additional data on the second tab when it's re-sorted (and it will be the only way to add in the page breaks). I am an expert level Excel developer and would love to work with you on this!