I have a workbook that is 100 sheets long with 26 columns with varying
rows that update daily( currently as high as 500) . I am in the
process of creating a executive summary of the workbook on a separate
worksheet that needs the last cell in each worksheet to post to the
exec summary. Anyone have any ideas that might make this easier than
doing this manually every day

Gary