Insert data from Sheet B into consecutive tables on Sheet A

I apologize in advance if my description for this is sub-par.

Sheet A has multiple tables organized in a way that caters to printing-- one table per page-- and the data for these tables is in Sheet B. I would like to be able to link the tables on Sheet A so that they run the data of Sheet B consecutively and can be sorted A-Z.

As for the list of data on Sheet B: each column coincides with a matching column on Sheet A's tables. I would prefer this list to also be a table to keep it from being a headache when we have to add more data, but it's not a big deal if that's not possible.

Any help you can give me is greatly appreciated.

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

DO NOT post a blank sheet. Your jpg is totally uninformative. Put in some data and some expected results so that we can see what you want.