what criteria needed to copy non blank cells to another location?

J

jill.mullen

I am trying to collate multiple worksheets to a single master sheet. then
e-mail all non blank cells ? I have managed to collate, but can't sort a
criteria to copy all non blank cells to a new location to then e-mail
HELP

and I AM A NEWBIE ON EXcel........................ so assume I know nothing!
thanks
 
Top