Hi all!

I have a very tedious by-hand method in excel that I'd like to create a code for. I have no experience with macros but some experience with scripting. I'm mentioning this because every time I use a "code" listed in the forum I'm not really sure if I'm putting it in the right place so any hints on the correct way to use macros would be helpful as well.

Here's the process:
I have a 10 column worksheet, each with 3 sections (the sections are defined by the range of rows)
Each column contains blank and nonblank cells (the nonblanks being just numerical values)
I would like to define each section (which does not vary column to column), then paste only the nonblank values (the location of which do vary), each into a separate worksheet in a new workbook (so 30 sheets total)

Is this possible? I've looked over many codes and haven't found anything. I wish I knew macros better because then I could just piece a few together, but it's pretty foreign to me. Thanks for your help!