This is done quite regularly for mechanically welded part plans for example or for assembly plans.
After that, if the plan has an assembly in the first sheet and in the following sheets the detail plans of all the parts that make up the assembly, you may quickly end up with a huge file.
As a general rule, we avoid, except for plans with nomenclatures where the (or sheets) corresponding to the description of the elements may be of different size than that of the plan itself.
I use several sheets only for welded mechanics, one sheet for the cutting and dimensioning part of the weld, another sheet for machining rework. Classic parts are made with one file per plan, the plan number is also the name of the file.
But as was said before, it's doable, but depending on the number of sheets, the file may quickly gain weight.
For us, it is very common to "juggle" between several formats. In fact, he has the overall plans that are between A0 and A1, the detail plans often A4 to A2. The "Paper" plans are very provisable for the time of a presentation for the manufacture or directly for the realization. Archiving remains very computerized so it doesn't matter the format.
In my other professions, the electrical diagram remained in A3 (easy to print in large volumes) and clear enough for a realization. In addition, the plans were still given to customers (internal or external) in this format. All the cover pages, nomenclatures, ... were often in A4.
For the DDE, architecture,... The A0 or A1 is very common, see a little special formats of Type A0 elongated for some buildings.