Hello everyone, My apologies for being a bit of a dummy. Perhaps if I hang about I might learn more.

I am currently working with a spreadsheet actually multiple which I am sure could be consolidated with a bit of know how.

The spreadsheet is a maintenance log of activity that happens on various boats.

It looks a bit like;

Vessel name - Date - Action - Person - Charge

Then as this spreadsheet has all vessels and the company wants each vessel to have its own the same data is re typed into a new spreadsheet that looks the same just excludes all other vessel info.

From their yet another spreadsheet is prepared that creates the invoice - Way too much typing and re typing

I am sure that in the past I have been able to have a spreadsheet whereby I enter all data into sheet one and then I use a formula whereby sheet 2,3,4,5 can be formulated to collect the relevant data from sheet 1...... if that makes any sense at all???