I have a work sheet where I am copying multiple worksheets
to, I would like to programatically do this, but unsure of
how to have it look down Column A until it gets to the
first Empty Cell and then paste. Was looking at the
IsEmpty function but not sure that applies. I also would
like to know how I can get the first empty cell in a
column. A bit lost on this and I am sure it is very
simple. something like Sheets("Sheet1").Cells(isempty)

That is my wild guess. Any help would be appreciated.

Wally Steadman