Extracting data from multiple worksheets, from differing number of rows

[leeboh]

Hi All,

I am working on a large project to determine all of the different fields that appear within a particular software system. I have a worksheet for every screen, with each worksheet detailing the Field names, along with other information.

I am looking to create a Master worksheet if it were (or summary worksheet) that shows all of the fields that appear across all of the different worksheets (screens).

The tricky part here is:

All of the Field names defined, start from Cell B7, but the total number of fields, i.e. the total rows the Field names spans, varies from worksheet to worksheet. And to make matters more complex, at the end of the listed fields, there are 2 blanks and then there is additional information continued, such as Links and Buttons information (which is not needed for the Master/Summary worksheet, but is needed in the individual worksheet it currently exists in).

Any thoughts of a formula on this?

Additionally, I also need to state which worksheet (Screen Name) the data was taken from. I can then later run a query of sorts to show duplicates as 1 result, detailing the multiple worksheets (Screen Names) in which they appear.

Any help would be greatly appreciated, this would solve a massive roadblock I'm facing with a large project at work.

Many thanks,



Lee

 

[Fluff]

Change this

If Not Ws.Name = "Master" Then

to

If Not Ws.Name = "Master" And Not Ws.Name= "[COLOR=#0000ff]Fluff[/COLOR]" Then

Where Fluff is the name of the worksheet

 

[leeboh]

Amazing, thank you so much Fluff!

 

[Fluff]

My pleasure