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.

The following formula will work, but only for your very specific situation. Here are the requirements.

1. There are two other worksheets that you are summarizing
2. The data in your summary sheet is in the same columns as in the other two worksheets
3. Every row of data will have a nonblank entry in column A
4. There is one header row on all three worksheets

If any of these is violated, it won't work.

If there is no data for the corresponding row, the string "No data" will appear. In this case it also appears in Summary column D because none of the rows have "Description" filled in.

Paste this formula into A2 in Summary then copy across all columns to D and down as many as you need.

=IF(ROW()<=COUNTA(V_Mori!A:A),INDEX(V_Mori!A:A,ROW()),IF(ROW()<=COUNTA(V_Mori!A:A)+COUNTA(CNC_Lathe!A:A)-1,INDEX(CNC_Lathe!A:A,ROW()-COUNTA(V_Mori!A:A)+1),"No Data"))

Brent, please reread the forum rules and retitle your thread.

On second look, you said you had "several" tabs of data. This formula gets very unwieldy if you try to extend it to include more worksheets, and eventually you will bump into the limit of nested IFs. What does your real data look like?

[Overtaken by events]