thanks max for the help, but it's not exactly what i was looking for, i
dont think i was clear enough about what i needed. i get data sheets
from different people, they are always in a different order, but have
the same heading for each column. i wanted to pull the data from the
different people and make a separate sheet that automatically puts the
columns of data in the order i want it.

for example.
on monday i receive a data sheet with the following columns...
id# name address phone# car birthday

on tuesday i receive a data sheet with the following columns...
birthday name address car phone# id#

what i want is a template that after i input the given data would place
all the information into an order i need it to be in... such as...
id# birthday name phone# address car