Merge data from 3 different sheets to one

Hello,

I have excel where i have different sheets. I want to merge data from sheet "TT logi Mon", "Workhours (not project)" and "logi Begin" to sheet "OUTPUT".

I have put right formulas to get the data i want. Rows 1-198 i have data from "TT logi Mon", rows 199-285 i have data from "Workhours (not project)" and rows 289-293 i have data from "logi Begin".

I want to excel automatically generate OUTPUT and fill with rows (as many rows as there is in 3 sheets (TT logi Mon, Workhours(not project) and logi Begin)) and they have to be in one table, under each other.

Thanks,
Siim

Hello,

Any other ideas to get this kind of information to one table?

Siim

maybe Use Power (Query), Luke

add-in for Ex2013