Hi.
I'm a structural engineer and I'm developing a spreadsheet to use for batch designing concrete columns (pillars). The workbook is split into a number of different sheets. Sheet 1 is used for setting up the data in terms of concrete column size, label, forces imported from another programme etc. Sheet 2 is used for doing checks on the size and slenderness of the column and choosing an appropriate design method. Sheet 3 is used for specifying the required steel reinforcement and a the final sheet 4 is summary sheet. Sheets 2 references data on sheet 1, sheet 3 references data on sheets 2 and 3 and sheet 4 reference data on sheets 1,2 and 3. Sheets 2 and 3 also contain inputs that are not dependent on or linked to the other sheets. The number of rows in each sheet is always the same, but the number of columns varies.

I want to sort data on the first sheet according to a number of criteria and have the other sheets automatically sorted too. I can write a macro to do this on one sheet, but I can't do it across multiple sheets. The problem I have is that when I sort info on sheet 1, I can't get the info on sheets 2 and 3 that is input only on those sheets (i.e not a reference to, or a calculation based on sheet 1 data) to also sort based on the new order from sheet 1. A simple example would be that column A on sheet 2 is a reference to column A on sheet 1, but column B on sheet 2 consists of independent inputs. When sheet 1 is sorted based on a particular order for column A, Column A in sheets 2 is automatically re-ordered, but column B on sheets 2 is not, which means that the sheet 2 data has to be re-entered.
if I have all of the info on 1 sheet then this problem goes away, but the spreadsheet then becomes far too cumbersome to use.

I'm fairly new to VBA, with no programming experience and my macro writing is very much a hack and bash approach with the record macro function and what I can glean from Internet forums.
All suggestions welcome!

thanks
Chris