hi,

i need a macro to create sheets from master and copy data from list to new worksheet. i have the following list:

Name Age Gender
Alex 23 Male
Lee 32 Female
Mike 53 Male
Sandy 18 Female


The macro has to copy the row data such as "Alex" (cell A2) and paste to the new sheet's range (H22:K22), copy "23" (Cell B2) and paste to the new sheet's range (M25:P25) and copy "Male" (Cell C2) and paste to the new sheet's cell H28. Just to remind that the new sheet are created from Master. The macro will continued the copy and paste of the next row data to the next sheet until the last row which contained data ("Sandy"). The new sheets created has to be rename according to Name columns data.

Thanks in advance