Thanks, snb--I appreciate the help. That gets me close, but still doesn't automatically sort on the Budget & Attendance tab when new non-chronological events are added on the Event Schedule tab.

For example, if i add a row on the Event Schedule, the data I need transfers to the Budget & Attendance tab perfectly, but any data that had been entered on that tab previously and related to the event date does not sort within the original row it was included. So what happens is everything in the first 3 columns shifts, but the remaining 15 columns don't move at all.