Cycle throuhg rows on a sheet

i need the functions to cycle throuhg the rows on each sheet and output data in this format


For Sheet X
For I to Count total rows
output

specific Sheet!A4&CHAR(10)&
Specific Sheet!B4&CHAR(10)&
specific Sheet!C4&CHAR(10)&
IF(ISBLANK(specific sheet!D4),"Det. 2014",Notostraca!D4&CHAR(10)&"Det. R. G. Ahlers 2014"))

anyoen able to help?

Collection Sheet.xlsx

here is my workbook
what i want is data to look like the first cell on the label sheet..but the function has to check each of the sheets to gather all that data

ok in your code how woudl i set the range to start at A4 instead of A1

as in A4 is the first point a record would be founnd?

ok my bad i was mis understainding the code...
when i run it i get blank cells adde dbecasue the shet hsa nothign on it yet..how would i account for that..im assuming an if statement right?

when i have multiple rows on a sheet filled in wiht the data it only spits out the first row

ah ok thx ill have a go at it

Ok im lost woith what to do from her..i can get them to combine well

Please Login or Register  to view this content.

here is waht i got...but its not working perfectly

Please Login or Register  to view this content.