combining sheets into 1

[cybergremlin]

Hi all.

I have a worksheet that contains 8 sheets, 6 data sheets(data 1, data 2 etc), 1 control sheet and a combined sheet.

I'm trying to combine the data sheets into the "combined" sheet and exclude the info on the control sheet.
each data sheet is setup identical with headers in cells B2:K2 but each data sheet has different numbers of rows.
the other problem i have is that not each cell has something in it so selecting them is causing me issues.

any help would be appreciated

 

[kweaver]

Does "combine" mean add the corresponding cells?

 

[cybergremlin]

sorry i mean i want to get the data from each data tab into 1 other tab