I would like to consolidate all the sheets into one Summary sheet. However, here the difficult that I find is every time the starting range to copy the data varies. In one excel file all sheet range start from B12 but in another file all the sheets range start from C13.
Is there any way that we can incorporate an input box which will ask for the starting cell to copy from. So once I give “B12” for example, it should copy from B12 until the last row of column B from all the sheets and paste in summary sheet.
Please advice if this is possible.
Thanks,
Vignesh
Bookmarks