Hi,

My lab is running a program that produces data for each file on separate
work sheets with 54 lines of data per sheet. I now need to compiled all of
the data from each sheet into one worksheet, with one row per file (one
file=one person in research project). I've heard a macro is the way to do
this but have little to no experience with this. My worksheets are piling up
and I can't imagine having to copy and paste these every time!

Any thoughts would be very much appreciated -- thank you in advance for your
time!!