Say I've created the following tables in Excel:

Electronic Wedge
Date Received Lot # Exp. Date Date Opened Initials
1/5/2008 56489 2/7/2008 1/10/2008 WG
4/7/2008 58469 5/2/2008 4/10/2008 TS
8/6/2008 59885 9/7/2008 8/10/2008 RF


Apples
Date Received Lot # Exp. Date Date Opened Initials
1/5/2008 56489 2/7/2008 1/10/2008 WG
4/7/2008 58469 5/2/2008 4/10/2008 TS
8/6/2008 59885 9/7/2008 8/10/2008 RF


Oranges
Date Received Lot # Exp. Date Date Opened Initials
1/5/2008 56489 2/7/2008 1/10/2008 WG
4/7/2008 58469 5/2/2008 4/10/2008 TS
8/6/2008 59885 9/7/2008 8/10/2008 RF


Not pivot tables, just columns and centering and lines around the cells.
Now say I've got about 30 to 40 items now and they are not arranged in any
kind of order. Is there a way to arrange all of these tables in ascending
order by product without having to cut and paste? I am wanting to make some
tables similar to this, but I need to know what I should do so that I can
easily sort them by product name. Any ideas?