Transferring data between sheets using macros

Hello,

I am having difficulty getting this to work. My original intention was to use a For Loop with an If check, but here is what I am trying to do.

I have a pre-made spreadsheet meant to sort my employees into "departments" evenly. That works ok, but the nature of the sheet gives the Output in a difficult to read format (lots of spaces and '0' values), but shows all 4 departments on one sheet.

What I thought I would do is create a tab for each department, and use a command button to basically pull all the info from the Output tab into the current tab. I want to use an If check so that if there is not a string value in the cell, it will skip that one and on the next line of the "final output", let's call it, it basically skips all the blanks and gives the names in a nice neat format.

I am looking to output across 4 columns, and then down varying rows (up to 51 in the longest column).

My question, I guess, is what is the proper way to reference a worksheet.

I was using Cells(Output!x, A) but got an error.
I then tried setting a variable as a Worksheet, and naming it "Output", and using Cells(var.x, A)

Any help would be greatly appreciated! Thanks in advance!