I've been asked to create a set of separate worksheets containing action-item lists (along with other items also on the worksheets). The lists will start on varying row #s and will vary in length (number of rows) but the column names will be consistent. I can make the lists into named ranges easily. I want to create one master list on a separate sheet (or in a separate workbook) that I can sort/filter. I do NOT need to edit the master list; just output it for printing/viewing at a meeting.

Most help articles I've read recommend the consolidate via pivot concept, and I've tried this. But the pivot wants to count or sum the information, and I can't get all of the columns to display. I just want to display all of the list information in a concatenation of the ranges. I don't think a VLOOKUP will give me what I need, because the ranges have varying numbers of rows.

Are there ways to do this without complex VBA or macros?