Summarize data from multiple worksheets onto one

I am trying to do a spreadsheet that has several tabs with data and one tab that will summarize data from the others. I know how to get data from another tab, but what I don't know is how to get all the data from one tab, then skip a couple lines and start from the beginning of the next tab. I have tried a couple of different if statements, but that doesn't seem to be the correct answer. In the attached file the pink columns will be hidden, they are just used to complete another cell. Thanks in advance for any help.