Please can you help with this.

I have 6 workbooks with one sheet in each that is identical - with text data
in

I need to design a 'master' sheet that when one is updated so is the master.

The amount of rows will differ for each sheet but the column names are the
same in the same place.

Thanks is advance