copying worksheets into one
 

Hello! I need help---new at excel. I'm combining data from multple
worksheets into one worksheet. The worksheets have some of the same column
headings as well as different column headings. I've hidden the unneeded
column headings. When I try to copy the worksheets into the one, the data
does not end up in the right column. I've tried copying visible cells
only--didn't work. I will be doing this once a month and need to be able to
do this. Any suggestions?