we use a product at work that has about 25 different sheets on them. i want to make a sheet that uses the last row of data on each sheet and puts all that information on 1 sheet (everytime the last row of information changes i need that other sheet to show the new information). i have no idea how to use that vba stuff. if anyone is willing to play with my product and see what they can do it would help me out alot thanks Jamie