hi

i need to create a worksheet based on various bits of data from other worksheets.

how do i get the data from say m1 on worksheet C and enter it into A1 on worksheet a ?

Also is it possible to use other equations in the process as what i would ideall want to do is =LEFT(J2,FIND("-",J2)+1) and add the resulting value into another worksheet.

Thanks in advance