In a workbook / file, one sheet named ‘summary’ contains some names in column A. The other sheets (e.g. ‘Test’) are named with the same name as contained in various rows in Column A of summary sheet. Now I want the values written in Test sheet to be automatically posted to Summary Sheet - Column B, Column C, etc. against the row in which Test is written in Column A. What may be the formula / function.