Indirect - cells - worksheet

[mystic42]

HI

I am having problems with the following Issue:

Over 50 sheet containing information for different divisions - name contains spaces and special characters
Data Range would be B:L contains headers and title text but the data required always starts at Row 8

The number of Rows varies from sheet to sheet eg. 80 rows to 0 (nothing entered)

Any new data added to a sheet must be reflected to another sheet called "Summary"

In the Sheet "Summary" First Row contains headers

What I need is the data from the other sheets to be reflected in Columns C - L, I need to have the sheetname in column A and column B notes can be made (manually)

I have tried different formulas such as =INDIRECT("'" & $A2 & "'" &"!B"&ROW(B8)) but this didn't work for me as the next sheet the row should be 8.

I seem to be going around in circles and have tunnel vision in this regard.

I was some one with another perspective can help.

Thanks in advance for any help

Regards

Andrea


I hope that I have been clear in what I need. The "Summary" sheet should have well over 2000 rows.

 

[Special-K99]

Attach a sample spreadsheet with expected results, remove any sensitive data.
You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

 

[mystic42]

Sorry, hope this works:

Zippyshare.com

 

[mystic42]

It seems as if there is a problem with zippyshare, so I have uploaded to dropbox.

https://www.dropbox.com/s/hidpc93ewjuy8nm/Sample.xlsx?dl=0

Cheers

Andrea