I have 2 workbooks. The first contains data for events that I run and the
data for each event is on a seperate worksheet. The second workbook is a
summary of all the events and as such gets updated after each event. I want
to automatically insert the data from cell A3 of sheet1 in the first workbook
to cell D4 in the summary workbook and I know how to do this but is there any
way of replicating the formula in cell D4 so that it changes to sheet2,
sheet3 etc. Thanks for your help