Relation Topic

Hi,

I need the idea on the relation issue.

I make an automated quotation generator using Glideapps.
For example,
1st sheet is the general information.

Quotation No without Revision | Quotation No with Revision | Revision No | Revision +1 | **
** Customer Name | Detail 1… 2…3…|

Example: Quotation No is 2105-0001-Rev.0 (if New quotation)
It become 2105-0001-Rev.1 > 2105-0001-Rev.2 … (if its revised)

2nd sheet is the model information’s with all the long calculation
3rd sheet is the payment information’s
and etc.

Its all relation with quotation no.

My problem is I want to keep the data as this if revised:
Because currently it can add row at the main sheet only.
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…

but its copy and keeps on all sheets.

like have this in 1st sheet
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…

in 2nd sheet
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…

in 3rd sheet
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…

Let me know if you guys not understand my question.