How to create independent worksheets using data in columns in a s.
 

I have a summary sheet for inputting departmental information with one column
for each department. I want to set up a seperate worksheet for each
department the information in the first few lines of each column of the
summary sheet automatically entered into the corresponding worksheet and also
have the worsheet name input automatically. Is this possible?

Thanks