pulling changing number of rows into another sheet, where you have categories in rows

i have a template document for which data can be populated. categories of information are populated both in columns and rows, meaning within a column you can also have categorisation of data. I want to be able to pull data from sheet1 into sheet2 were the rows in sheet2 will adapt depending on sheet1 and no space will be shown between the rows categories.