I have a workbook with 200+ worksheets. i am wanting to pull data from each worksheet into a summery worksheet. I then want to be able to set up one row on the summery sheet that pulls the relevent data from the other sheets and autofull down. at the moment i have to manually edit each formula to link it to the "next" sheet and it drives me crazy.
screenshot attached which should explain better
Autofill.jpg
Bookmarks